Grant RESOURCE role to him.
kev wrote:
>
> Hi,
>
> I've just created my first user :-)
> However, I got an error (insufficient priveleges) when I tried to create
> a table, so I logged on as SYS and did a 'grant create table to
> newuser'. Then I had to do the same to create a sequence, and then to
> create a trigger.
> I don't want to have to keep granting priveleges, every time I want to
> do something as newuser. How do I create a new user that has table,
> trigger, sequence, etc priveleges?
>
> - Kev
Received on Thu Jul 29 1999 - 08:00:08 CDT
