1. 首页
  2. IT资讯

alter user test default role all except create_table;

http://203.208.39.132/search?q=cache:HWVo-k7-Qd8J:www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_4003.htm+alter+user+default+role+all+except&cd=2&hl=zh-CN&ct=clnk&gl=cn&client=aff-360homepage&st_usg=ALhdy2_P-vPWNNI9YlOWQTrNdipSu_5X9w[@more@]

alter user test default role all except create_table; 什么意思?

Select * from dba_role_privs中存在default 属性,缺省给用户授予的角色都是yes,就是logon以后可以使用的,如果是no的,需要在会话中

问题:角色授权的时候如何指定非缺省?如何修改角色的这个属性为缺省?为何要设定非缺省?

激活角色除了salary_adm

2009-10-9 13:40测试 exception …

创建一个本地管理的、一个extent区扩展是128k扩展16blocks的表空间

Create tablespace tbs_test datafile ‘F:ORADATATESTtbs_test_01.DBF’ size 20m autoextend on maxsize Unlimitedextent management local uniform size 128ksegment space management auto;

Alter Tablespace tbs_test add datafile ‘F:ORADATATEST tbs_test_02.DBF’ size 10m autoextend on maxsize Unlimited;

改变数据文件的

This clause is valid only for bigfile tablespaces. It lets you increase or decrease the size of the single datafile to an absolute size. Use K, M, G, or T to specify the size in kilobytes, megabytes, gigabytes, or terabytes, respectively.

To change the size of a newly added datafile or tempfile in smallfile tablespaces, use the ALTER DATABASEautoextend_clause (see database_file_clauses ).

Alter Database Datafile ‘F:ORADATATESTtbs_test_02.DBF’ Resize 10m; 设置数据库的缺省用户表空间为tbs_test

Alter databse default tablespace tbs_test;

建立临时表空间组

Create temporary tablespace temp_test_01 tempfile ‘F:ORADATATESTtbs_temp_test_01.dbf’ size 20m Autoextend On Next 1m Maxsize Unlimited ,‘F:ORADATATESTtbs_temp_test_02.dbf’ size 20m Autoextend On Next 2m Maxsize Unlimited,‘F:ORADATATESTtbs_temp_test_03.dbf’ size 20m autoextend on Next 3mmaxsize unlimitedextent management local Uniform size 128ksegment space management Manual tablespace group tbs_grp_temp_01;查看组成员

Select * from dba_tablespace_groups;

设置数据库的缺省临时表空间组

Alter database default temporary tablespace group_temp;

检查设置的参数是否正确

Select * from database_properties;

–create user 使用自定义的缺省表空间和临时表空间

Create user test identified by test;

打开profile的口令校验,然后关闭口令校验

Alter profile default limit password_vertify_function null;

./rdbms/profile/utlpwdmg.sql

授予系统权限和角色

Grant create session to test;

创建角色create_table

Create role create_table ;

Grant create any table ,drop any table to create_table;

授权

Grant create_table to test;

查看当前用户角色中的default

GRANTEE GRANTED_ROLE ADMIN_OPTION DEFAULT_ROLE

TEST CREATE_TABLE NO NO

如何启动?

只能通过

Alter user test default role all ;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/450962/viewspace-1027671/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:布吉卡,转转请注明出处:http://www.cxybcw.com/194794.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code