Thinking Out Loud

February 7, 2013

CLI versus GUI

Filed under: oracle — mdinh @ 3:47 am

extract_user.sql

Lately, I have been working more with CLI after having some dependencies on GUI.

No worries, there is not a lack of information from Google to steal what you want.

Good artists copy, Great artists steal – Steve Jobs

Here is an example on how to recreate the user with the same password and privileges.

C:\SQL>sqlplus system/oracle @extract_user.sql scott

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 22:28:38 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

CREATE USER "SCOTT" IDENTIFIED BY VALUES 'S:635FFF7EF7E7AA0C4E561203F88246E6B426778B26E6D86B3478778A6AC5;F894844C34402B67'
DEFAULT TABLESPACE "USERS"
TEMPORARY TABLESPACE "TEMP";
--
GRANT "CONNECT" TO "SCOTT";
GRANT "RESOURCE" TO "SCOTT";
GRANT "DBA" TO "SCOTT";
GRANT "PLUSTRACE" TO "SCOTT";

GRANT UNLIMITED TABLESPACE TO "SCOTT";
GRANT EXECUTE ON "SYS"."DBMS_CRYPTO" TO "SCOTT";

******************************
Execute: cr_extract_user.sql
******************************
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

To verify the password is indeed the same as the original, I created user mdinh with the same hash value for the password.

C:\SQL>sqlplus system/oracle

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 22:29:07 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create user mdinh IDENTIFIED BY VALUES 'S:635FFF7EF7E7AA0C4E561203F88246E6B426778B26E6D86B3478778A6AC5;F894844C34402B67';

User created.

SQL> grant dba to mdinh;

Grant succeeded.

SQL> conn mdinh/tiger
Connected.
SQL> conn scott/tiger
Connected.
SQL>

As you can see, both scott and mdinh are tiger.

What do you prefer more, CLI or GUI?

About these ads

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 272 other followers

%d bloggers like this: