Home » SQL & PL/SQL » SQL & PL/SQL » how to grant all normal user previleges in a single statemnt.. (oracle 9i ,windows xp)
how to grant all normal user previleges in a single statemnt.. [message #322533] Sat, 24 May 2008 03:48 Go to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

hw do i have to grant all sysoper previleges to new user account..


thanks &
regards
seyed mohamed M
india..
Re: how to grant all normal user previleges in a single statemnt.. [message #322536 is a reply to message #322533] Sat, 24 May 2008 04:25 Go to previous messageGo to next message
seyed456
Messages: 220
Registered: May 2008
Location: south india .
Senior Member

i found out myself. ..
grant dba to user;
Re: how to grant all normal user previleges in a single statemnt.. [message #322565 is a reply to message #322536] Sat, 24 May 2008 09:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know what you found but SYSOPER and DBA are 2 things completly different with no relation at all.

Regard
Michel

[Edit: missing word]

[Updated on: Sun, 25 May 2008 03:16]

Report message to a moderator

Re: how to grant all normal user previleges in a single statemnt.. [message #322615 is a reply to message #322565] Sun, 25 May 2008 03:09 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
In addition to Michels remark:
sysoper is not "all normal user privileges" as you imply in your topic title
Previous Topic: Sequence skip numbers in oracle
Next Topic: How to create user in Oracle ?
Goto Forum:
  


Current Time: Sat Dec 03 20:22:16 CST 2016

Total time taken to generate the page: 0.22127 seconds