OraFAQ Forum: Security » Create role

Home » RDBMS Server » Security » Create role

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create role [message #29802]

Tue, 23 March 2004 08:20

JAC
Messages: 12
Registered: February 2003

Junior Member

Hi gurus,

I have created a user 'A' with CONNECT grant.

from my user 'B' I made:

CREATE ROLE tbaccess;
GRANT INSERT, SELECT, DELETE ON b.mytable TO ROLE tbaccess;
GRANT TBACCESS TO A;

BUT from my user 'A' I can't view b.tbaccess.

where is the problem?

�

Thanks

�

Report message to a moderator

Re: Create role [message #29805 is a reply to message #29802]

Tue, 23 March 2004 08:48

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

How is A trying to access the table?

select * from tbaccess;
 
select * from <b>b.</b>tbaccess;

If without the user prefix (b.), user A will need to either use the prefix or create a synonym.

Report message to a moderator

Previous Topic:	Tables - roles
Next Topic:	Trouble with 'grant' procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 16:41:07 CST 2025