By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,417 Members | 1,825 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,417 IT Pros & Developers. It's quick & easy.

copy a role

P: n/a
hi,
just wonder, can we copy a role then add some new priviledges to the
new role.
hm.. i means, example; now i have a role named role_a. Then I copy
role_a to create role_b. After I created role_b from role_a, i would
like to revoke some privileges in role_b without affecting role_a. Can
I and how to write the script?

regards,
tracy
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
tr********@yahoo.com.hk (tracy) wrote in message news:<5c**************************@posting.google. com>...
hi,
just wonder, can we copy a role then add some new priviledges to the
new role.
hm.. i means, example; now i have a role named role_a. Then I copy
role_a to create role_b. After I created role_b from role_a, i would
like to revoke some privileges in role_b without affecting role_a. Can
I and how to write the script?

regards,
tracy


When a newsgroup has sub-groups you should generally post only to the
sub-groups. Many newsreaders no longer carry comp.databases.oracle
anymore so you are missing access to many of the better board readers.

You can query sys.role_tab_privs to generate a list of object
privileges granted to the role.

In the case of where you just want to add a few additional privileges
to what an existing role has you can grant the existing role and the
new privs to the new role.

When you want to remove privileges then you have to create a new role
and perform all the necessary grants to it.

HTH -- Mark D Powell --
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.