Home » RDBMS Server » Security » grant privileges
grant privileges [message #73815] Sun, 18 July 2004 07:26 Go to next message
Messages: 56
Registered: November 2001
i create a new user

and asigning privileges to that user by sql query


sql>grant select,insert,update,delete on all_tables(user tables)

to imran(user name or role name);

that query is not executed

so plz write the correct query and solve my prob


Re: grant privileges [message #73816 is a reply to message #73815] Sun, 18 July 2004 12:58 Go to previous message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
If you just want user imran to be able to insert, update, and delete from his own tables, that happens automatically, as long as imran has been granted connect and resource or quota on some tablespace.

If you want user imran to be able to insert, update, and delete from all other users' tables, then your grant statement is correct, but you need to be connected to an account with sufficient privileges to grant it, such as system as sysdba, when you execute the grant statement.
Previous Topic: example to give privs on packages instead of give privs directly on table to user
Next Topic: How can audit in details
Goto Forum:

Current Time: Thu Dec 01 10:12:34 CST 2022