create user 用户名 IDENTIFIED by 密码 [default tablespace 表空间名]---创建用户 grant create session to 用户名;--给用户授权登录 drop user 用户名;--删除用户 1. 2. 3. 4. 5. --授予用户操作表空间的权限: grant unlimited tablespace to 用户名; grant create tablespace to 用户名; grant alter ...
5. SYS账户收回user_a的CREATE TABLE权限: 6. 此时user_b仍可具有CREATE TABLE权限,尽管这里报错: 注:这个错是说user_b没有默认表空间USERS的使用权限,并不是没有建表权限,此时需要SYS账户使用GRANT UNLIMITED TABLESPACE TO user_b或ALTER USER user_b quota 100m on USERS让user_b用户可以使用USERS表空间: ...
注:这个错是说user_b没有默认表空间USERS的使用权限,并不是没有建表权限,此时需要SYS账户使用GRANT UNLIMITED TABLESPACE TO user_b或ALTER USER user_b quota 100m on USERS让user_b用户可以使用USERS表空间: 总结: 1. 带有WITH ADMIN OPTION的权限授予方式,可传递授权。 2. 带有WITH ADMIN OPTION的权限授予...
5. SYS账户收回user_a的CREATE TABLE权限: 6. 此时user_b仍可具有CREATE TABLE权限,尽管这里报错: 注:这个错是说user_b没有默认表空间USERS的使用权限,并不是没有建表权限,此时需要SYS账户使用GRANT UNLIMITED TABLESPACE TO user_b或ALTER USER user_b quota 100m on USERS让user_b用户可以使用USERS表空间: ...
6. 此时user_b仍可具有CREATE TABLE权限,尽管这里报错: 注:这个错是说user_b没有默认表空间USERS的使用权限,并不是没有建表权限,此时需要SYS账户使用GRANT UNLIMITED TABLESPACE TO user_b或ALTER USER user_b quota 100m on USERS让user_b用户可以使用USERS表空间: ...
The owner of the schema containing the table must have space quota on the tablespace to contain the table. ALTER ANY TABLE Alter a table or view in any schema except SYS, AUDSYS. BACKUP ANY TABLE Use the Export utility to incrementally export objects from the schema of other users ...
grant CREATE SYNONYM to TEST; grant CREATE ANY SYNONYM to TEST; grant UNLIMITED TABLESPACE to TEST; Oracle Object Privileges These are granted on database objects (such as a table, view, procedure, etc.…) The owner has all the privilege’s and an owner can give specific privilege’s on ...
[DEFAULT TABLESPACE default_tablespace ] [TEMPORARY TABLESPACE temp_tablespace] [QUOTA size |UNLIMITED ON tablespace_name] [PASSWORD EXPIRE] [ACCOUNT LOCK|UNLOCK] //user_name要创建的数据库用户的名称,不能与现有的用户名重复 //IDENTIFIED 用户指定数据库用户的认证方式,password要创建用户的密码,即密码认证...
dba_tablespaces;TABLESPACE_NAME---SYSTEMSYSAUXUNDOTBS1TEMPUSERSSQL> create user usera identified by usera 2 default tablespace users 3 temporary tablespace temp 4 quota unlimited on users;User created.SQL> grant create session, create user to usera;Grant succeeded. 由于usera已被授予create user特权...
alter user username quota [amount] on mytablespace; To grant select, insert, update and delete on objects you have to run a separate grant command for each table: grant select, insert, update, delete on mytable1 to username; ... Share Improve this answer Follow answered Jun 1, 2011...