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

Thread: dba priviledges

  1. #1
    Join Date
    Oct 2000


    I granted some people DBA priviledges but I just realized that, I want them to do everything with the exception of modify a table. What is the best thing to do in order for them to do everything but not to modify a table?

  2. #2
    Join Date
    Sep 2000

    You could do something like:

    -- Create a role

    $ sqlplus system/manager
    SQL> create role user_role;

    -- Grant all the necessary the previliges to this role
    SQL> grant select, insert, update, delete on emp to user_role;

    -- Grant this role to the users
    SQL> grant user_role to scott;

    Hope this helps!

  3. #3
    Join Date
    Nov 2000
    When you say "modify a table" do you mean insert,update, delete data? If so:
    1. create role READONLY;
    2. grant select any table to READONLY;
    3. grant READONLY to userA;

    If you mean don't let the users modify the structure of the table, but allow them to change any of the data then:
    1. create role USE_ALL_TABLES;
    2. grant select any table to USE_ALL_TABLES;
    3. grant insert any table to USE_ALL_TABLES;
    4. grant delete any table to USE_ALL_TABLES;
    5. grant update any table to USE_ALL_TABLES;
    6. grant USE_ALL_TABLES to userA;
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.