|
-
Why the role is not working?
user1 logged in
create table table1 (id integer not null);
create role role1;
grant select on table1 to role1; //so the role could select from table1
grant role1 to user2; // so user2 should be able to select table1, right?
user2 logged in
select * from user1.table1;
ORA-00942: table or view does not exist
Why role1 is not working here? How do I check which privileges have been granted to role1? i.e. which data dictionary view should I check?
Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|