{"id":128,"date":"2011-07-05T04:08:55","date_gmt":"2011-07-05T01:08:55","guid":{"rendered":"http:\/\/fatihacar.com\/blog\/?p=128"},"modified":"2011-07-08T18:31:15","modified_gmt":"2011-07-08T15:31:15","slug":"users-roles-and-grants-in-oracle","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/users-roles-and-grants-in-oracle\/","title":{"rendered":"Users, Roles and Grants in Oracle"},"content":{"rendered":"

Oracle has predefined accounts which are SYS and SYSTEM user. These users can not be drop. SYS user has all privileges with Admin Option. If you want to connect SYS account, you must use the AS SYSDBA or AS SYSOPER clause. Any user can connect SYSDBA privilege by using the AS SYSDBA clause. Only privileged users who are granted the SYSDBA or SYSOPER privilege are allowed to STARTUP and SHUTDOWN the database instance.<\/p>\n

Create and Drop User<\/strong><\/p>\n

CREATE USER User_Name IDENTIFIED BY User_PassWord;
\nDROP USER User_Name;<\/p><\/blockquote>\n

Create and Drop Role<\/strong><\/p>\n

CREATE ROLE Role_Name;
\nDROP ROLE Role_Name;<\/p><\/blockquote>\n

Grant and Revoke<\/strong><\/p>\n

GRANT create table,create sequence,create session,create procedure,create view to User_Name (User,Role,Public) [WITH GRANT OPTION]<\/p>\n

Note : If you use WITH GRANT OPTION, This user can give own role to other user. <\/p>\n

GRANT update(department_id,department_name) ON departments TO Role_Name;<\/p>\n

REVOKE create table FROM User_Name;<\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"

Oracle has predefined accounts which are SYS and SYSTEM user. These users can not be drop. SYS user has all privileges with Admin Option. If you want to connect SYS account, you must use the AS SYSDBA or AS SYSOPER clause. Any user can connect SYSDBA privilege by using the AS SYSDBA clause. Only privileged…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9],"tags":[92,90],"class_list":["post-128","post","type-post","status-publish","format-standard","hentry","category-administration","tag-administration","tag-oracle"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-24","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=128"}],"version-history":[{"count":8,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/128\/revisions"}],"predecessor-version":[{"id":130,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/128\/revisions\/130"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=128"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}