What privilages do you need to allow a user to perform this select?
GRANT what??? TO USER;
Printable View
What privilages do you need to allow a user to perform this select?
GRANT what??? TO USER;
grant select on tab to user
Uhm, err.......hmmmmmmm
How many guesses do we get?
I'll go with TRUNCATE.
:D
MH
C'mon Dave, it's Friday, let's have some fun with this one!!Quote:
Originally posted by slimdave
grant *** on tab to user
MH
Hi
Grant connect, resource to USER
HTH
SS
That makes sense...Quote:
Originally posted by slimdave
grant select on tab to user
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...:confused:
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
No.
But it does work for;
select * from sys.tab;
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.Quote:
Originally posted by Srinivas_Sharma
Hi
Grant connect, resource to USER
HTH
SS