S:\>sqlplus
SQL*Plus: Release 11.1.0.6.0 - Production on Mon Jul 30 18:09:19 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name: system
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create user username identified by Password;
User created.
SQL> grant connect,resource to username;
Grant succeeded.
SQL> alter user username account unlock;
User altered.
SQL>
SQL*Plus: Release 11.1.0.6.0 - Production on Mon Jul 30 18:09:19 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name: system
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create user username identified by Password;
User created.
SQL> grant connect,resource to username;
Grant succeeded.
SQL> alter user username account unlock;
User altered.
SQL>
No comments:
Post a Comment