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]