469,282 Members | 2,119 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,282 developers. It's quick & easy.

user authorazation

Hi,
I confuse. I had a role named lsc_role with certain object privs. if i
run this query :
select role from dba_role;

ROLE
-----------------------
JAVADEBUGPRIV
EJBCLIENT
JAVA_ADMIN
JAVA_DEPLOY
CTXAPP
XDBADMIN
AUTHENTICATEDUSER
LBAC_DBA
OLAP_DBA
SALES_HISTORY_ROLE
LSC_ROLE

i can see the role exists. but when i try to see the object privs
granted to lsc_role with this query :

SQL> select *
2 From role_tab_privs
3 where role = 'LSC_ROLE';

no rows selected
User who granted LSC_ROLE is still working, mean access is restricted
as what was assigned to this role.

Why i can see the object privs assigned to them in second query?

I granted the role lsc_role to user using id: abc who has dba role.

I wonder is that only grantor can see grantees? Hm.. means, id dba_1
created and granted role_a to user b. When dba_2 run tthis query:
SQL> select *
2 From role_tab_privs
3 where role = 'role_a';
dba_2 will see nothing, am I right?

In this case, which userid is better when dba want to create or
granted a role or role; using a his own id or conn as sysdba?

more confuse now!!

thanz.

regard,
lclim
Jul 19 '05 #1
0 1836

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

60 posts views Thread by Fotios | last post: by
3 posts views Thread by zlst | last post: by
6 posts views Thread by martin | last post: by
2 posts views Thread by rn5a | last post: by
1 post views Thread by Carlettus | last post: by
reply views Thread by leecho | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.