Re: help with an error message

From: Rus Rayburn <rus_at_localhost.localdomain>
Date: Sun, 16 Jan 2000 02:17:10 -0500
Message-ID: <Pine.LNX.4.10.10001160210150.1778-100000@localhost.localdomain>

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