OraFAQ Forum: Server Administration » New Oracle User with certain privileges

Home » RDBMS Server » Server Administration » New Oracle User with certain privileges

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

New Oracle User with certain privileges [message #56554]

Tue, 08 April 2003 10:40

Arpit
Messages: 99
Registered: March 2001

Member

Hello All,

I need to create a new oracle user to connect a web application to the Oracle database.

this user needs to have read permissions on two tables
and read,create,modify,delete permissions on one table

I'm aware of the create user syntax:

create user <user name> identified by <pwd>

but am not sure what to use for granting these read permissions on two tables and full permissions on one table.

Any help on this ASAP would be highly appreciated.

Thanks!

Report message to a moderator

Re: New Oracle User with certain privileges [message #56556 is a reply to message #56554]

Tue, 08 April 2003 11:17

Anand
Messages: 161
Registered: August 1999

Senior Member

Login as the user that owns the tables and then issue the command :

SQL> GRANT SELECT ON table_name TO user_name;

This will give Read permission on the table.

For full rights :

SQL> GRANT ALL ON table_name TO user_name;

A

Report message to a moderator

Previous Topic:	Help in Oracle Server Manager
Next Topic:	LOG_CHECKPOINT_INTERVAL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 07:50:03 CDT 2024