-
编辑 删除
ora-15064会不会跟没有安装asmlib有关?
SQL> ALTER DISKGROUP ALL MOUNTNOTE: cache registered group DATA number=1 incarn=0x41fce947NOTE: cache began mount (not first) of group DATA number=1 incarn=0x41fce947NOTE: cache registered group HIST number=2 incarn=0x41fce948NOTE: cache began mount (not first) of group HIST number=2 incarn=0x41fce948NOTE: cache registered group NL02 number=3 incarn=0x41fce949NOTE: cache began mount (not first) of group NL02 number=3 incarn=0x41fce949NOTE: cache registered group SYSD number=4 incarn=0x41fce94
-
编辑 删除
拥有dba角色的普通帐号在pl sql中查sys的对像时仍需显式授权
今天ronon在etl帐号下创建下述过程,查询分区表的分区键数据类型,发现执行过程时出错, 而etl帐号是有dba角色的.关键点：在PL/SQL里面select 表的权限需要单独赋予的。即使你是DBA用户 (不能依赖于role-based privileges), 更深一层的原因以后给出.所以，语句中如果引用了其它帐号的对像，一定要注意这一点.[@more@]SQL> col GRANTEE for a10SQL> col GRANTED_ROLE for a15SQL> SQL> select grantee,GRANTED_ROLE,ADMIN_OPTION,DEFAULT_ROLE from DBA_ROLE_PRIVS where grantee in('ETL') order by grantee;GRANTEE GRANTED_ROL
