Home » RDBMS Server » Security » Create role
Create role [message #29802] Tue, 23 March 2004 08:20 Go to next message
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

 
Re: Create role [message #29805 is a reply to message #29802] Tue, 23 March 2004 08:48 Go to previous message
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.
Previous Topic: Tables - roles
Next Topic: Trouble with 'grant' procedure
Goto Forum:
  


Current Time: Sat Apr 10 14:32:02 CDT 2021