-
select * from tab
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
-
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
I remember when this place was cool.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|