I am trying to work out how database roles work. Here is my user case...
create role user1 login password 'user1'; create schema authorization user1; CREATE ROLE DEV_ROLE; grant connect, temporary on database test to DEV_ROLE; GRANT ALL ON SCHEMA manager TO DEV_ROLE;
Now how do i view the all the grants assigned to 'DEV_ROLE'? This is possible in Oracle but trying to work out the same here.
Do appreciate your reply. Ta