Home » RDBMS Server » Security » grant privileges
grant privileges [message #73815] Sun, 18 July 2004 07:26 Go to next message
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 Go to previous message
Barbara Boehmer
Messages: 9077
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: Tue Mar 19 03:26:18 CDT 2024