-
I want to create users and give them priviledges that they can do everything with the exception of dba priviledges. I do not want them to create tablespaces either but they can pretty much create all objects, procedures, triggers,etc.
What is the appropriate priviledge to give them?
I am thinking that I have to grant them connect and resource roles only. I'm sure with those priviledges they can pretty much do most things like creating objects but can't create a tablespace. Any suggestions/help?
[Edited by learn on 11-28-2000 at 04:31 AM]
-
User priviliges
Hi learn,
The best you can probably do is to query the dba_sys_privs and dba_role_privs views and select the roles and or privileges you want to grant to your users.
Than create a role which holds all the privileges you want to grant to your users.
Then grant this role to your users.
HTH
tycho
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|