Re: no priveleges for new user

Basically grant connect , resource to USER pretty much covers it. I also like to revoke unlimited tablespace from USER

after this, since it comes with resource and I don't like it.

• Dc.

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 Fri Aug 06 1999 - 10:24:06 CDT