| Creation of New Username & Password in SQL*PLUS? [message #157207] |
Wed, 01 February 2006 01:00  |
malar_dm
Messages: 31
Registered: December 2005
Location: Chennai,India
|
Member |
|
|
Hi friends!
I need ur guidance regarding oracle database security system.
I want to create new username and password like scott and tiger in sql*plus.According to my knowledge, I went to administration assistant for windows nt/oracle, in that i select the action menu – connect database. It shows new window. By default OS authenticated connection as sysdba get selected, simply I select connect button.
In the database tree, it displayed external os users,local roles,external os roles,os database administrators, os database operators.
I select local roles, it list out the users like AQ_USER_ROLE,DBA etc.,
I created new user, named as MALAR1. In that I Right click and select the properties, it displayed general, system privileges & roles.
In general I applied the new password & click apply and ok.
But the user not get created, when I applied in Sql*plus. Ultimately the password also get changed in MALAR1 properties.
I herewith attach the templates for this process
Please do help........
Thank u.
With regards
Malar.d
-
Attachment: Templates.doc
(Size: 637.50KB, Downloaded 2884 times)
[Updated on: Wed, 01 February 2006 01:02] Report message to a moderator |
|
|
|
| Re: Creation of New Username & Password in SQL*PLUS? [message #157231 is a reply to message #157207] |
Wed, 01 February 2006 03:33  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
Malar,
The steps you have followed are NOT the recommended way of creating a user in Oracle. The recommended way is, to use the create user command to create the user. to give one example :
SQL> create user tmp11 identified by tmp11
2 default tablespace TBS01
3 quota unlimited on TBS01
4 quota unlimited on TBI01
5 quota 0 on SYSTEM
6 temporary tablespace TEMP01;
User created.
SQL> grant connect, resource, create sequence, query rewrite, create table, create view,
2 create materialized view to TMP11;
Grant succeeded.
SQL> connect tmp11/tmp11@mnph
Connected.
(Thus i created the user tmp11 and gave him some previlages..remember that the previlages you give have to give may be different depending on your requirement.)
You can refer to Oracle docs at
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/users.htm#15245
for details..
|
|
|
|
| Re: Creation of New Username & Password in SQL*PLUS? [message #157380 is a reply to message #157231] |
Thu, 02 February 2006 01:37 |
malar_dm
Messages: 31
Registered: December 2005
Location: Chennai,India
|
Member |
|
|
Hi,
Thanks a lot, for ur timely help. The problem get solved. I created a new username & password. But another doubt arises, in the connectivity of database from sql*plus to Forms Builder(d2k), I m not able to connect the database. It shows error message stating (ORA -12560:TNS: protocol adaptor error).
From my knowledge, I went to ODBC Data Source Administrator and select connection pooling, in that I select the oracle and enable it and click apply & ok. But it not get connected.
I herewith attach the print screen for easy understanding.
Username : system
Password : password
Pls do help….
Thank u.
With regards
Malar.d
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
