0

im using oracle db v21c , after trying to create a role student with privs 'create session , create table , create view ' a granted that role to a user 'user3' but when trying to connect with that user i got ora-01045. i checked that privs granted to that role and everything seems normal , i have tried using granting the role the privileges with admin option and nothing happens . I used select * from dba_sys_privs where grantee='student' and all seems good . The role is created with system and so the user because at first i was trying to create the role with scott , but get an error insufficient privileges, but scott have the privilege to create role.

kiraXdesu
  • 1

1 Answers1

1

Roles are not active by default. You must either alter the user to set a default role (and then login again), or alter the user's current session to set a current role:

alter user user3 default role all;

or

set role student;
pmdba
  • 6,457
  • 2
  • 6
  • 16
  • I tried what you said , even though it should work , but it didn't i guess there's a problem with my oracle version , there may be same bugs running on . Thanks anyway – kiraXdesu Jun 08 '22 at 15:56