GRANT SELECT ON TABLE(s) FOR ALL USERS [message #346700] |
Tue, 09 September 2008 07:58  |
keizersoz
Messages: 16 Registered: April 2006
|
Junior Member |
|
|
Hello all,
I would like to grant SELECT privilege only on some specific tables to all users.
The syntax I found on the internet is GRANT SELECT ON <TABLE> [B]TO USER [/B] Problem is that I have to specify this statement for each user separately. Is it possible to execute this for ALL_USERS at once? If yes what should the syntax be?
Many thanks in advance,
Keizersoz
|
|
|
|
|
|
|
|
Re: GRANT SELECT ON TABLE(s) FOR ALL USERS [message #346717 is a reply to message #346709] |
Tue, 09 September 2008 08:48   |
keizersoz
Messages: 16 Registered: April 2006
|
Junior Member |
|
|
please discard my previous question.problem occurs when I execute from SYSTEM
I have 2 more questions:
(1) Why can't I grant select from SYSTEM user? I receive an error when doing so.
(2)Why don't I see in the 'Oracle Enterprise Manager' for all #users the affected tables in the 'Object privileges'
Many thanks for your appreciated help.
regards,
keizerso
|
|
|
Re: GRANT SELECT ON TABLE(s) FOR ALL USERS [message #346725 is a reply to message #346716] |
Tue, 09 September 2008 09:02   |
keizersoz
Messages: 16 Registered: April 2006
|
Junior Member |
|
|
my actual problem is as follows: Imagine I have 5 users
A,B,C,SYSTEM, SUPER_USER
Now I would like SUPER_USER to have access to specific tables from all users except from SYSTEM, in this case there are only 3 users A,B,C.
If I understand well I have for each of the specific users, namely A,B,C to execute GRANT SELECT ON <table> to SUPER_USER.
Is that correct?
thanks and regards ,
keizersoz
|
|
|
Re: GRANT SELECT ON TABLE(s) FOR ALL USERS [message #346735 is a reply to message #346717] |
Tue, 09 September 2008 09:50  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Quote: | (1) Why can't I grant select from SYSTEM user? I receive an error when doing so.
|
Quote: | Copy and paste what you tried.
|
Quote: | (2)Why don't I see in the 'Oracle Enterprise Manager' for all #users the affected tables in the 'Object privileges'
|
quoting Ana (anacedent): | Those who live by the GUI, die by the GUI.
|
Quote: | If I understand well I have for each of the specific users, namely A,B,C to execute GRANT SELECT ON <table> to SUPER_USER.
Is that correct?
|
Yes.
Once again read the link I provided, there is nothing in addition to what is in this link.
Regards
Michel
|
|
|