Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help with an error message

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US