Re: no priveleges for new user

kev <kevin.porter_at_fast.no>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦ news:37A04EB5.91E07A1D_at_fast.no¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> 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
>

Create a role and grant system privileges to it. And grant the role to a new user.
Role = Set of System or Object Privileges Received on Thu Jul 29 1999 - 08:32:36 CDT