Home » RDBMS Server » Server Administration » how to Gant rights and privileges to new user
how to Gant rights and privileges to new user [message #51920] Fri, 21 June 2002 05:38 Go to next message
mayur
Messages: 10
Registered: November 2001
Junior Member
Hi

I want to know how to grant rights and privileges to a new user

mayur

Report message to a moderator

Re: how to Gant rights and privileges to new user [message #51935 is a reply to message #51920] Fri, 21 June 2002 15:15 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
GRANT "ROLE" TO "USER";
GRANT "PRIVILEGE" ON "OBJECT" TO "USER";

example:

GRANT DBA TO BAD_HACKER;

GRANT DELETE ON EMPLYEES_SALARY TO BAD_HACKER;

:-)))

Hope that helps,

clio_usa
OCP - DBA

Visit our web site [url=http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi]Click Here

Report message to a moderator

Previous Topic: what is the NOLOGGING effect on Table
Next Topic: 9i upgrade from 8i...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 17 20:32:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.