IDS Forum

RE: restricting creation of databases

Posted By: Javier Zayas
Date: Thursday, 11 September 2003, at 12:29 p.m.

In Response To: restricting creation of databases (Javier Zayas )

I know that 9.30 has this option as I've been able to search the archives
and find that as a solution. However, when I try to use the same syntax in
7.3.1.UC4 it doesn't seem to do anything. Does anyone know if 7.x versions
of IDS have this parameter available or if there is a similar parameter
available for me to set.

TIA

Javier Zayas
System Administrator
x73143

-----Original Message-----
From: Rajib Sarkar [mailto:rsarkar@us.ibm.com]
Sent: Thursday, September 11, 2003 8:21 AM
To: Javier Zayas
Cc: forum.subscriber@iiug.org; ids@iiug.org
Subject: Re: restricting creation of databases [1824]





If you are on 9.30 there's an ONCONFIG parameter DBCREATE_PERMISSION where
you can specify which users can create databases.

HTH

Thanx much,

Rajib Sarkar
Advisory Software Engineer (RAS)
IBM Data Management Group
Ph : (602)-217-2100
Fax: (602)-217-2100
T/L : 667-2100

As long as you derive inner help and comfort from anything, keep it --
Mahatma Gandhi




"Javier Zayas "

<javier_zayas@cuc.cla To: ids@iiug.org

remont.edu> cc:

Sent by: Subject: restricting
creation of databases [1824]
forum.subscriber@iiug

.org





09/10/2003 04:09 PM







Hello folks,

I'm trying to find out if there is a way to restrict database creation via
sql for users with connect and resource access. Basically, I'm supposed to
be supporting an application that uses Informix and have to manually
restore
to another system. What I'm finding is that one particular user has learned
how to create new databases outside the scope of the application and they
are causing my restores to fail on my backup system since those tables are
not part of the backup system when I do my restores. Any help in figuring
out how to restrict either creation of databases in sql, creation of
databases in general, or how to restrict what users can do in sql (isql)
would be really great. Thanks in advance. I will summarize for the list.

Javier Zayas
System Administrator
Claremont University Consortium
javier.zayas@cuc.claremont.edu <mailto:javier.zayas@cuc.claremont.edu>
http://www.cuc.claremont.edu <http://www.cuc.claremont.edu>
(909)607-3143

Messages In This Thread

• restricting creation of databases
  Javier Zayas -- Wednesday, 10 September 2003, at 7:09 p.m.
  • RE: restricting creation of databases
    Murray Wood \(IList\) -- Wednesday, 10 September 2003, at 9:55 p.m.
  • Re: restricting creation of databases
    Rajib Sarkar -- Thursday, 11 September 2003, at 11:24 a.m.
    • Re: restricting creation of databases
      Jonathan Leffler -- Thursday, 11 September 2003, at 1:44 p.m.
  • RE: restricting creation of databases
    Javier Zayas -- Thursday, 11 September 2003, at 12:29 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.