摘要:
授予系统权限:GRANT { system_privilege | role }[,{ system_privilege | role }]... ...TO {user | role | PUBLIC }[,{user | role | PUBLIC }]... ...[WITH ADMIN OPTION]回收系统权限:REVOKE {system_privilege | role}[,{ system_privilege | role }]... ...FROM {user | role | PUBLIC}[,{user | role | PUBLIC }]... ...对于使用了WITH 阅读全文
摘要:
创建用户:CREATE USER user --创建用户userIDENTIFIED {BY password | EXTERNALLY} --设备用户密码,EXTERNALLY说用该用户由操作系统授权,该参数在创建用户时不能省略。[DEFAULT TABLESPACE tablespace] --设置用户的默认表空间[TEMPORARY TABLESPACE tablespace] --设置用户的临时表空间[QUOTA {integer[K|M] | UNLIMITED} ON tablespace [QUOTA {integer[K|M] | UNLIMITED} ON tables... 阅读全文