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
Messages: 11
Registered: February 2007
Location: Chennai,India
Junior Member

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:
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: 65085
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

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

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: Sun Jul 23 21:51:20 CDT 2017

Total time taken to generate the page: 0.08521 seconds