RE: Restricting "Create Database"

I know of no way to revoke create database privileges from someone who is allowed to connect on the instance. Will >===== Original Message From mcwillij@my-deja.com ===== >I feel like a bona-fide idiot posting this question, but can't find an >answer anywhere. We're running IDS 7.3x(blah, blah, whatever) on >Solaris 2.5.1. Here's the problem I have. On our development instance >we developers often create databases in the rootdbs. We try to keep it >pretty clean so that some idiot loading 1 million rows of data without >adequate space won't cripple the engine. That means we have to import >databases out of the dbspace almost daily. > >Keeping in mind that we typically allow public connect and select >access on most databases in this instance, how can I restrict anyone >from creating a database, or limit them to a default database (somewhat >like Oracle does with a default user database setting in their profile)? >I know that I can use UNIX "group" privileges to control access to the >instance and objects, but in this case that won't help. Is role based >security the answer? > >Any help is appreciated. Respond here or to mcwillij@fdhc.state.fl.us > >Thanks, > >Jake > > >Sent via Deja.com http://www.deja.com/ >Before you buy. ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------

Hi, Revoke DBA Privilege from the developers. Grant thepermission Connect and if they require to create the tables then grant them Resource privilege. * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful