Home » RDBMS Server » Server Administration » Grants
Grants [message #52472] Wed, 24 July 2002 16:42 Go to next message
NiGger
Messages: 6
Registered: July 2002
Junior Member
Hi everybody
Anybody knows why if a run this script Nothing happends:

GRANT SELECT ANY TABLE,INSERT ANY TABLE,UPDATE ANY TABLE

TO USER

WITH ADMIN OPTION;

the user after this modification still without the rigths to update ,

but to select and insert there's no problem

Thanks in advanced

NiGger

Report message to a moderator

Re: Grants [message #52474 is a reply to message #52472] Wed, 24 July 2002 20:45 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Run the grants with only one grant per statement. That should take care of your intentions.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: How to kill oracle shadow processes
Next Topic: alter table characterset
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 13:35:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.