Home > oracle > ALTER ROLE system privilege

ALTER ROLE system privilege

We’ve created a super-privileged user, that needs a lot of system privileges.

Now, we need this user to do:

 ALTER ROLE <role_name> NOT IDENTIFIED;

The privilege it needs is

GRANT ALTER ANY ROLE TO <user>;

If you want a complete list of system privileges and its corresponding grant, have a look at this https://netfiles.uiuc.edu/jstrode/www/orasql/system_privs.html

Advertisements
Categories: oracle Tags: , ,
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: