How to grant privileges automatically to newly created user?

[Oracle10]

Hi all,

I have created a user and I want that all the privileges(select,update,insert,delete etc) should be automatically granted to this newly created user.Please anybody can tell me how can I do that?

Thanks in Advance...

[debasisdas]

Can u tell me what do u mean by ALL THE PREVILAGES.

What actually u want to grant

Object level previleges ---with/without GRANT option
or
System level previleges.--------with/without ADMIN option

[Oracle10]

Can u tell me what do u mean by ALL THE PREVILAGES.

What actually u want to grant

Object level previleges ---with/without GRANT option
or
System level previleges.--------with/without ADMIN option

Yah Deb ..I want to grant object level previleges without grant option.

Thanks

[debasisdas]

1.Create a ROLE

2.Grant the previledges u want to grant to the user to the role.

3.Grant the role to the user.


Advantages----If u grant like this granting/revoking previledges becomes more manageble. In future the same bundle of previledges can be granted to another user also without having to grant multiple times.

[Oracle10]

1.Create a ROLE

2.Grant the previledges u want to grant to the user to the role.

3.Grant the role to the user.


Advantages----If u grant like this granting/revoking previledges becomes more manageble. In future the same bundle of previledges can be granted to another user also without having to grant multiple times.

You mean everytime a new user is created the role has be granted by somebody with admin rights...but my requirement is as soon as a new user is created those privileges should be granted automatically without anybody typing commands to grant privileges or roles.Is it possible through trigger or procedure or may be oracle has some facility for that?

To explain myself for example
Lets say I created a user .Now as user it created 'grant create session to user' and 'grant select to user' should be granted automatically either through role or one by one.How can I achieve it?Please can you let me know the step to achieve this.

Thanks

[debasisdas]

please follow these steps


1.Create a role;

2.Grant the previledges to the role;

3.Grant the role to PUBLIC;

Note:--PUBLIC means to all the users of the database;

4.Create a new user;

Automatically the new user will get all the previledges that is being granted to the ROLE;


Hope this solves your problem.

[Oracle10]

Thanks Deb its working

please follow these steps


1.Create a role;

2.Grant the previledges to the role;

3.Grant the role to PUBLIC;

Note:--PUBLIC means to all the users of the database;

4.Create a new user;

Automatically the new user will get all the previledges that is being granted to the ROLE;


Hope this solves your problem.

[debasisdas]

You are always welcome
feel free to post your questions/doubts in the forum
But give a try from your side first
and also put how u have tried to solve this question.
it will help experts of the forum in understanding and solving your problem in a better way.

thanx
debasis