What privilages do you need to allow a user to perform this select? GRANT what??? TO USER;
Last edited by jhutchin; 10-24-2003 at 10:08 AM.
grant select on tab to user
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
Uhm, err.......hmmmmmmm How many guesses do we get? I'll go with TRUNCATE. MH
I remember when this place was cool.
Originally posted by slimdave grant *** on tab to user C'mon Dave, it's Friday, let's have some fun with this one!! MH
Hi Grant connect, resource to USER HTH SS
Originally posted by slimdave grant select on tab to user That makes sense... TAB is a view but the user does not seem to be able to see it. ORA-00942: table or view does not exist. Any offers...
Is the user prefixing the name of the owning schema in the select or has a synonym for the object been created in the users schema? e.g. SELECT * FROM owner.table_name
Jim Oracle Certified Professional "Build your reputation by helping other people build theirs." "Sarcasm may be the lowest form of wit but its still funny" Click HERE to vist my website!
No. But it does work for; select * from sys.tab;
Originally posted by Srinivas_Sharma Hi Grant connect, resource to USER HTH SS Don't like it -- RESOURCE is a role that is probably either too broad or too narrow in scope for a particular situation. I would define my own.
Forum Rules
Reply With Quote
Bookmarks