User Management - Revision history

Stuart: /* Unsupported way */

2018-09-26T07:56:05Z

‎Unsupported way

2018-09-26T07:55:08Z

‎Unsupported way

2018-06-14T14:14:06Z

‎Rename an Oracle schema without exporting and importing all schema data

2017-05-08T15:26:01Z

‎Create external user

2016-09-19T15:22:42Z

‎Create external user

2016-04-13T15:14:42Z

‎On Windows...

2016-01-22T11:44:24Z

‎Users created when installing Oracle 11.2.0.4 Enterprise Edition

2016-01-22T11:44:15Z

‎Users created when installing Oracle 11.2.0.4 Standard Edition

2016-01-22T11:43:49Z

‎Users created when installing Oracle 11.2.0.4 Standard Edition

2016-01-22T11:29:30Z

‎Create external user

@@ Line 131: / Line 131: @@
 </pre>
 <pre>
-update sys.user$  set name = 'KPK' where user# = 172;
+update sys.user$ set name = 'KPK' where user# = 172;
 </pre>
 <pre>

@@ Line 123: / Line 123: @@
 An unsupported workaround to rename a schema is to simply update the username in sys.user$ and restart the database.
 <pre>
-select user_id from dba_users where username = 'EPK';
+select user# from sys.user$ where name = 'EPK';
 </pre>
 <pre>

@@ Line 119: / Line 119: @@
 * Set password for new user account and set default tablespace for this new account
 * Drop old user account representing the schema before renaming
 ===Create external user===

@@ Line 105: / Line 105: @@
 connect by grantee = prior granted_role;
 </pre>
 ===Create external user===
 ====Check the authentification prefix====

@@ Line 75: / Line 75: @@
 </pre>
 ===Create external user===
 ====Check the authentification prefix====

@@ Line 96: / Line 96: @@
 grant create session to "ops$domainname.com\oracle";
 </pre>
-Additionally, the following option must be set in "%ORACLE_HOME%\network\admin\sqlnet.ora"
+Additionally, the following option must be set in "%ORACLE_HOME%\network\admin\sqlnet.ora"<br />
 <pre>
-SQLNET.AUTHENTICATION_SERVICES= (NTS)
+SQLNET.AUTHENTICATION_SERVICES=(NTS)
 </pre>

@@ Line 38: / Line 38: @@
 ===Users created when installing Oracle 11.2.0.4 Enterprise Edition===
 <pre>
-SYS@CISPRO1P> select username from dba_users order by 1;
+select username from dba_users order by 1;
 USERNAME

@@ Line 3: / Line 3: @@
 ===Users created when installing Oracle 11.2.0.4 Standard Edition===
 <pre>
-SYS@ATHARCHT> select username from dba_users order by 1;
+select username from dba_users order by 1;
 USERNAME
@@ Line 35: / Line 35: @@
 rows selected.
 </pre>
 ===Users created when installing Oracle 11.2.0.4 Enterprise Edition===
 <pre>

@@ Line 1: / Line 1: @@
 * [https://oracle-base.com/articles/misc/os-authentication Create external user (using OPS$)]
 * [[Create User like...]]
 ===Create external user===
 ====Check the authentification prefix====