Home » SQL & PL/SQL » SQL & PL/SQL » select privilege problems
select privilege problems [message #242124] Thu, 31 May 2007 13:27 Go to next message
sherifbasha
Messages: 11
Registered: February 2007
Location: Chennai,India
Junior Member

Hi,
Can anybody solve my problem?
I created a EMP table , created a role 'sample' to select EMP table. I have created a new user with connect,resource privilege and granted 'sample' role to it and also created a private synonym of EMP for that user.

Now the problem when I connect the new user I am not able to select the EMP table nor with owner.EMP also. It show table or view does not exists.Please help Is there any problem with role creation?

Message was edited by:
user557563
Re: select privilege problems [message #242140 is a reply to message #242124] Thu, 31 May 2007 14:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't word what you did, just copy and paste your screen.
And read and apply How to format your posts

Regards
Michel
Re: select privilege problems [message #242184 is a reply to message #242124] Thu, 31 May 2007 23:50 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
sherifbasha wrote on Thu, 31 May 2007 20:27
Message was edited by:
user557563


Don't you think you could at least take the time to remove this part when you copy-pasted it from your Oracle forums thread?
Previous Topic: "ORA-01427: single-row subquery returns more than one row"
Next Topic: to find out sql statement executed on server
Goto Forum:
  


Current Time: Sat Dec 10 16:43:44 CST 2016

Total time taken to generate the page: 0.10936 seconds