Re: Granting privileges.

In our last gripping episode Unmesh Laddha <unmesh_at_thinking-minds.com> wrote:
> Hi,
>
> I am trying to duplicate all privileges of one user to another user.
> What is the most effective way to do it?
> Any feedback is appreciated.
>
> Thanks,
>
> Unmesh
>
>

The long way around is to determine the privileges the one user has and then specifically grant those privileges to the other user. A more efficient approach would be to use roles; determine the privileges of the "source" user then create a role and grant those privileges to it. Grant this role to all users who would need the same privileges.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.