一:no create session privilege
1:create user beyondsanli identified by beyondsanli;
这个时候用beyondsanli normal登录,报告no create session
这个时候要用system用户指定session权限
2:grant create session to beyondsanli;
3:revoke create session from sanli;
二:对表空间users无权限
grant resource to 用户;
表空间的配额而己.去查看此用户在USERS表空间中配额是否满了
grant UNLIMITED TABLESPACE to user
grant all on table_name to 用户
你登入的数据库帐号是不是没有权限创建数据库对象的权限呀。
你给他分配一个dba的权限呀。
三:修改用户的默认表空间
alter user username default tablespace tablespacename;
四:我用sysdba建了个表空间A,现在想为A再专门建个用户,并且给它所有有关A的权限,create user username identified by pwd default tablespace A;
grant connect, resource, DBA to username
五:
CREATE USER WEBPF
IDENTIFIED BY
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
/
GRANT CONNECT TO WEBPF WITH ADMIN OPTION
/
GRANT DBA TO WEBPF WITH ADMIN OPTION
/
GRANT RESOURCE TO WEBPF WITH ADMIN OPTION
/
GRANT UNLIMITED TABLESPACE TO WEBPF WITH ADMIN OPTION
/
这样创建的如何?
1:create user beyondsanli identified by beyondsanli;
这个时候用beyondsanli normal登录,报告no create session
这个时候要用system用户指定session权限
2:grant create session to beyondsanli;
3:revoke create session from sanli;
二:对表空间users无权限
grant resource to 用户;
表空间的配额而己.去查看此用户在USERS表空间中配额是否满了
grant UNLIMITED TABLESPACE to user
grant all on table_name to 用户
你登入的数据库帐号是不是没有权限创建数据库对象的权限呀。
你给他分配一个dba的权限呀。
三:修改用户的默认表空间
alter user username default tablespace tablespacename;
四:我用sysdba建了个表空间A,现在想为A再专门建个用户,并且给它所有有关A的权限,create user username identified by pwd default tablespace A;
grant connect, resource, DBA to username
五:
CREATE USER WEBPF
IDENTIFIED BY
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
/
GRANT CONNECT TO WEBPF WITH ADMIN OPTION
/
GRANT DBA TO WEBPF WITH ADMIN OPTION
/
GRANT RESOURCE TO WEBPF WITH ADMIN OPTION
/
GRANT UNLIMITED TABLESPACE TO WEBPF WITH ADMIN OPTION
/
这样创建的如何?