GRANT CONNECT TO username [ IDENTIFIED BY ] pwd

GRANT GROUP TO user

CREATE OR REPLACE ROLE groupname
FOR USER userid

GRANT MEMBERSHIP IN GROUP groupname [,...] 
TO grantee [,...]

GRANT ROLE groupname [,...] 
TO grantee [,...]

GRANT DBA TO grantee [,...]

GRANT ROLE SYS_AUTH_DBA_ROLE TO grantee [,...] 
WITH ADMIN OPTION
WITH NO SYSTEM PRIVILEGE INHERITANCE

GRANT REMOTE DBA TO grantee [,...]

GRANT ROLE SYS_RUN_REPLICATION_ROLE TO grantee [,...]
WITH ADMIN OPTION
WITH NO SYSTEM PRIVILEGE INHERITANCE

GRANT BACKUP TO grantee [,...]

GRANT ROLE SYS_AUTH_BACKUP_ROLE TO grantee [,...]
WITH NO SYSTEM PRIVILEGE INHERITANCE

GRANT RESOURCE TO grantee [,...]

GRANT ROLE SYS_AUTH_RESOURCE_ROLE TO grantee [,...]
WITH NO SYSTEM PRIVILEGE INHERITANCE

GRANT VALIDATE TO grantee [,...]

GRANT ROLE SYS_AUTH_VALIDATE_ROLE TO grantee  [,...]
WITH NO SYSTEM PRIVILEGE INHERITANCE

GRANT PROFILE TO grantee [,...]

GRANT ROLE SYS_AUTH_PROFILE_ROLE TO TO grantee [,...]

GRANT READCLIENTFILE TO grantee [,...]

GRANT ROLE SYS_AUTH_READCLIENTFILE_ROLE TO TO grantee [,...]

GRANT READFILE TO grantee [,...]

GRANT ROLE SYS_AUTH_READFILE_ROLE TO TO grantee [,...]

GRANT WRITECLIENTFILE TO grantee [,...]

GRANT ROLE SYS_AUTH_WRITECLIENTFILE_ROLE TO TO grantee [,...]

GRANT PUBLISH TO grantee

変更ありません。ただし、新しい PUBLIC オプションである db_publisher も設定できます。

SET OPTION PUBLIC.db_publisher=grantee

GRANT permission [,...] ON [ owner.]object-name
TO  grantee [,...]

permission : 
ALL [ PRIVILEGES ] 
| ALTER 
| DELETE 
| INSERT 
| REFERENCES [ ( column-name, ...) ] 
| SELECT [ ( column-name, ... ) ] 
| UPDATE [ ( column-name, ... ) ]

変更ありません。

GRANT EXECUTE ON [ owner.]{ proc | user-def-funct }
TO grantee [,...]

GRANT INTEGRATED LOGIN TO user-profile-name [,...] 
AS USER user

GRANT KERBEROS LOGIN TO userid [,...] 
AS USER user

GRANT CREATE ON dbspacename [,...] TO grantee [,...]