Oracle_ Create User _ Grant permission

Oracle_ Create User _ grant permission

--Create user, need sufficient permissions Create UserHzfidentified  by hzf;

- -to user bjsxt assign permissions   grant grant   connect , resource   to  hzf Grant DBA  to hzf;

-- REVOKE permission revoke revoke   connect , resource   from  hzf   

- -delete User Drop user hzf;

Permissions	Permission refers to the right to execute a specific type of SQL command or to access other objects
Role	A role is a combination of a set of permissions with a name
Common systems Pre-defined roles	CONNECT: Temporary user RESOURCE: More reliable and formal users DBA: The database administrator role, with the highest permissions to administer the database

Oracle_ Create User _ Grant permission