Got it

Authorize the created database user

254 0 0 0 0

Authorize the created database user

There are two built-in users inside oracle: system and sys. Users can log in directly to the system user to create other users because system has the authority to create other users. When installing oracle, the user or system administrator can first create a user for himself.

Authorization command, oracle is compatible with the previous version, providing three standard roles (role): connect/resource and dba.


Syntax: grant connect, resource to username;


 Example: grant dba, resource to dsdb;


Comment

You need to log in to comment to the post Login | Register

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.