DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: creating users

  1. #1
    Join Date
    Nov 2000
    Posts
    169

    Red face

    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]

  2. #2
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234

    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
  •  


Click Here to Expand Forum to Full Width