In a database it is very necessary to control the roles of a user; User in a database can have multiple roles. Roles can be either just for accessing the database like reading or writing or it can be read only role as well. The role a user is granted depends on the functionality it performs. Now before creating a database it is necessary to define roles of a user, it helps the dba to understand the users who can access and who cannot access the database.<\/p>\n
We use the command >>grant, To grant access to users. We can even identify the users with their name and password. SO, whenever a user wants to link to the database, the user has to connect using username and password.<\/p>\n
>>Connect Username\/password.<\/p>\n
For e.g.: we create a user by name scott and who can access the database with a password tiger, for this, we write:<\/p>\n
>>Connect scott\/tiger;<\/p>\n
Or >> connect scott<\/p>\n
Password tiger<\/p>\n
To create a new user we write the command >>create<\/p>\n
>>create user scott identified by tiger;<\/p>\n
This creates a user named scott and who can access the database using password tiger.<\/p>\n
In order to grant access to the user we write;<\/p>\n
>>Grant connect, resource, dba to user 1;<\/p>\n
For e.g.;\u00a0 >>grant connect, resource, dba to scott;<\/p>\n
Using this granting the user scott can connect to the database, access the resources and access the database as well.<\/p>\n
Hit like if you found this post useful.<\/p>\n","protected":false},"excerpt":{"rendered":"
In a database it is very necessary to control the roles of a user; User in a database can have multiple roles. Roles can be either just for accessing the database like reading or writing or it can be read only role as well. The role a user is granted depends on the functionality it […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[57],"tags":[222,221,224,220,120,223],"class_list":["post-198","post","type-post","status-publish","format-standard","hentry","category-general","tag-command-grant-in-sql","tag-grant-framework","tag-grant-in-sql","tag-grant-user-access","tag-learn-sql","tag-what-is-grant-user-access"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/dstarena.com\/blog\/wp-json\/wp\/v2\/posts\/198","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dstarena.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dstarena.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dstarena.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dstarena.com\/blog\/wp-json\/wp\/v2\/comments?post=198"}],"version-history":[{"count":3,"href":"http:\/\/dstarena.com\/blog\/wp-json\/wp\/v2\/posts\/198\/revisions"}],"predecessor-version":[{"id":3665,"href":"http:\/\/dstarena.com\/blog\/wp-json\/wp\/v2\/posts\/198\/revisions\/3665"}],"wp:attachment":[{"href":"http:\/\/dstarena.com\/blog\/wp-json\/wp\/v2\/media?parent=198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dstarena.com\/blog\/wp-json\/wp\/v2\/categories?post=198"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dstarena.com\/blog\/wp-json\/wp\/v2\/tags?post=198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}