Re: Newbie Question: Create user with all rights

There is no 'all' to grant except grant all on <some object> to username...

If you want to grant a set of privileges , create a role that has those privs and grant the role to the user...

sorry_at_no.mail.back.com (Sander) wrote:

>How can you create an user with all rights.
>I do it like this:
>create user "abc" identified by "pppwww" ........
>and then
>grant this
>grant that
>grant that
>....
>but is there something like grant all ?
>
>thanks in advance,
>Sander
Received on Mon Jul 31 2000 - 00:00:00 CDT