| grant privileges [message #73815] |
Sun, 18 July 2004 07:26  |
Imran
Messages: 56
Registered: November 2001
|
Member |
|
|
i create a new user
and asigning privileges to that user by sql query
example:
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
thanks
imran
|
|
|
|
| Re: grant privileges [message #73816 is a reply to message #73815] |
Sun, 18 July 2004 12:58  |
 |
Barbara Boehmer
Messages: 9102
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
