oracle role user

Solutions on MaxInterview for oracle role user by the best coders in the world

showing results for - "oracle role user"
Amélie
08 Feb 2017
1GRANT role_name TO user_name;
2ALTER USER user_name DEFAULT ROLE role_name;
3-- Check:
4SELECT * FROM DBA_ROLES WHERE ROLE = 'role_name';
5SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTED_ROLE = 'role_name' 
6	AND GRANTEE = 'user_name';
Anna
31 Jul 2016
1-- CREATE ROLE role_name [IDENTIFIED BY password] [NOT IDENTIFIED]
2CREATE ROLE role_name;
3GRANT CREATE SESSION, ALTER SESSION TO role_name;
4GRANT SELECT, INSERT, DELETE, UPDATE ON table_name TO role_name;
5GRANT EXECUTE ON proc_name TO role_name;
6-- Grant role to user
7GRANT role_name TO user_name;
8ALTER USER user_name DEFAULT ROLE role_name;
9SELECT * FROM DBA_ROLES WHERE ROLE = 'role_name';
10SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTED_ROLE = 'role_name' 
11	AND GRANTEE = 'user_name';
Elisa
07 Jul 2016
1GRANT role_name TO user_name;
queries leading to this page
grant privileges to user in oracleoracle grant schema to roleassign role to user oraclehow to grant a user to access another user table in oracle sqlhow to grant dba role to user in oraclehow to grant roles in oracleoracle sql grant roleoracle rolecreate role oracle 12coracle create roleoracle sql grant role to userhow to grant user role to schema in oraclehow to create role in oraclegive role to user oracleoracle sql grant privileges to role adminoracle 19 grant role to useroracle sql grant privileges to roleoracle create role privilegeoracle role useroracle grant all roles to useruser roles oracleoracle base create roleoracle 19 grant role to user as adminoracle grant admin role to usercreate role in oracle sqloracle user grantoracle grant role to usergrant role to role oracleprivileges of role oraclegrant all roles to db user oraclecreate role oraclecreate role oracle databasegrant table oracle to useroracle grant rolecreate role oracle exempleoracle grant catalog rolegrant role with admin option in oraclecreate user role in oraclecreate role in oracleoracle role syntaxgive privileges to role oraclecreate role oracle sqlgrant a role to a user in oracleoracle all roles to useroracle default role for usergrant database link to user in oraclehow to grant roles to user in oraclegrant privileges to role in oraclecreate role oracle syntaxgrant role to user oracleadd role to user oraclehow to find user roles and privileges in oracleoracle grant roles to usermake a role oracleoracle sql grant privileges to user admincreate role and grant privileges in oracleoracle create role exampleoracle add user to rolegrant user access to table oracleoracle role user