Home » RDBMS Server » Security » making a new user account
making a new user account [message #15244] Mon, 27 September 2004 04:32 Go to next message
richard101
Messages: 11
Registered: August 2004
Junior Member
Hi all

I'm adding a new user, (based on another user) and need to be sure about the authentication method.

Can I assume that if a user has a hex entry in the password column of dba_users then they are authenticated by Oracle?

 
Re: making a new user account [message #15253 is a reply to message #15244] Mon, 27 September 2004 06:10 Go to previous messageGo to next message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
Hi,

See script "Create database user like an exiting user (with exact privs)" at http://www.orafaq.com/scripts/

Best regards.

Frank
Re: making a new user account [message #15272 is a reply to message #15253] Tue, 28 September 2004 01:27 Go to previous message
richard101
Messages: 11
Registered: August 2004
Junior Member
Thanks Frank, thats a great script and I'm sure I'll use it after this time.

But - for my first time I want to use 'create user ...' and 'Grant ...' statements.

So, in response to the request ...

"Please create user [[user]] on the [[db]]. You can model the setup on the [[user2]] user that already exists.

The user will need read, write and execute access to a NEW schema called [[user]] within the [[ts]] tablespace."

... I now have ...

CREATE USER [[user]]
PROFILE default
IDENTIFIED BY [[user]]
DEFAULT TABLESPACE [[ts]]
TEMPORARY TABLESPACE temp
ACCOUNT UNLOCK
PASSWORD EXPIRE;

GRANT UNLIMITED TABLESPACE TO [[user]];
GRANT connect TO [[user]];
GRANT resource TO [[user]];
GRANT select ON [[ts]] TO [[user]];
GRANT insert ON [[ts]] TO [[user]];
GRANT execute ON [[ts]] TO [[user]];

... how does that look?
Previous Topic: Role and system privileges
Next Topic: Password
Goto Forum:
  


Current Time: Fri Dec 03 06:21:09 CST 2021