Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: help with an error message
Benny,
If all you did was the below, you might need to do a bit more.
Try this:
From SYSTEM
create user user1 identified by favoritepassword default tablespace userstablespace temporary tablespace temp quota 0 on system quota unlimited on temp quota unlimited on userstablespace; Then: grant connect, resource to user1;
Be carefull with the 'resource' grant. I've read (Honeybee book) that it permits anyone granted permission to store procedures in SYSTEM tablespace, but I've never run into the issue myself.
-Rus
On Fri, 14 Jan 2000, Legend wrote:
<snip>
> Could someone tell me what I need to do what I create a user? All I did was:
> grant connect,resource to user1 identified by usrpasswd;
</snip> Received on Sun Jan 16 2000 - 01:17:10 CST
![]() |
![]() |