| making a new user account [message #15244] |
Mon, 27 September 2004 04:32  |
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 #15272 is a reply to message #15253] |
Tue, 28 September 2004 01:27  |
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
