Re: user access to create tables

PK wrote:
> Gurus,
>
> Thanks for correcting me. However what if a new 'Schema' owner is being
> created ? What is the best practice for granting correct level of
> privileges eg. synonyms, triggers, procedures, tables etc? Are there
> any standard set of privileges or they should be granted as required
> only.
>
> Thanks
> Prashant

For creating a new schema write three scripts:

1. specifically creates privs needed to build the schema
2. specifically removes all privs not required by the application
3. specifically required to perform maintenance

#2 is essential to good security. You may need CREATE PROCEDURE to create it ... you never need it thereafter except for once a year maintenance.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)