{"id":114,"date":"2018-09-29T17:50:30","date_gmt":"2018-09-29T17:50:30","guid":{"rendered":"http:\/\/kabiliravi.com\/?page_id=114"},"modified":"2019-07-21T13:47:53","modified_gmt":"2019-07-21T13:47:53","slug":"user-management","status":"publish","type":"page","link":"http:\/\/kabiliravi.com\/index.php\/software\/databases\/oracle-db\/user-management\/","title":{"rendered":"User Management"},"content":{"rendered":"

Creating a User<\/h1>\n

Once you connect as a sysdba user, simply you can execute the CREATE USER command to generate a new DB user.<\/p>\n

Here is the command:<\/p>\n

SQL> ALTER SESSION SET \"_ORACLE_SCRIPT\"=true;\r\n\r\n\r\nSession altered.\r\n\r\nSQL> CREATE USER phonebookdba IDENTIFIED BY \"p123!@#\";\r\n\r\nUser created.<\/pre>\n
\n
Note if you get ORA-65096: invalid common user or role name<\/strong> error run <\/p>\n
SQL> ALTER SESSION SET \"_ORACLE_SCRIPT\"=true;<\/pre>\n<\/blockquote>\n
Grant Access<\/h1>\n
Grant to CONNECT role<\/h2>\n
The CONNECT role was established with<\/p>\n\n\n\n\n\n\n
Alter Session<\/td>\nCreate Session<\/td>\n<\/tr>\n
Create Cluster<\/td>\nCreate Synonym<\/td>\n<\/tr>\n
Create Database Link<\/td>\nCreate Table<\/td>\n<\/tr>\n
Create Sequence<\/td>\nCreate View<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Refer to Addressing The CONNECT Role Change<\/a> for more information<\/p>\n
Here is the command to grant a user CONNECT role:<\/p>\n
SQL> GRANT CONNECT TO phonebookdba;<\/pre>\n
Grant a user to be DBA<\/h2>\n
Sometimes you need to create a user with more privileges like allowing the user to create named types for custom schemas or even the DBA role that allows the user to not only create custom named types but alter and destroy them as well.<\/p>\n
SQL> GRANT CONNECT, RESOURCE, DBA TO phonebookdba;<\/pre>\n
 <\/p>\n
Alter User<\/h1>\n
 <\/p>\n
Drop User<\/h1>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Creating a User Once you connect as a sysdba user, simply you can execute the CREATE USER command to generate a new DB user. Here is the command: SQL> ALTER SESSION SET “_ORACLE_SCRIPT”=true; Session altered. SQL> CREATE USER phonebookdba IDENTIFIED BY “p123!@#”; User created. Note if you get ORA-65096: invalid common user or role name error […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":88,"menu_order":2,"comment_status":"open","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"class_list":["post-114","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/kabiliravi.com\/index.php\/wp-json\/wp\/v2\/pages\/114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/kabiliravi.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/kabiliravi.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/kabiliravi.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/kabiliravi.com\/index.php\/wp-json\/wp\/v2\/comments?post=114"}],"version-history":[{"count":6,"href":"http:\/\/kabiliravi.com\/index.php\/wp-json\/wp\/v2\/pages\/114\/revisions"}],"predecessor-version":[{"id":122,"href":"http:\/\/kabiliravi.com\/index.php\/wp-json\/wp\/v2\/pages\/114\/revisions\/122"}],"up":[{"embeddable":true,"href":"http:\/\/kabiliravi.com\/index.php\/wp-json\/wp\/v2\/pages\/88"}],"wp:attachment":[{"href":"http:\/\/kabiliravi.com\/index.php\/wp-json\/wp\/v2\/media?parent=114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}