解决办法:把自己所有的权限都给用户B。 grant all privileges to B;
plsql 的三种登录方式:normal 、sysdba、 sysoper 要开启os认证,首先需要确保你的netsql.ora文件开启了all 或者nts模式 不然是用不了os认证的 oracle...例如: sys 还有被赋予了sysdba角色的用户 show user USER 为”PUBLIC” 如果你想用system 登录 connection as sysdba 会出现ora-01031
问题 在Oracle中,SYS用户登录报权限不足(ORA-01031: Insufficient Privileges)的常见原因有哪些?...ERROR: ORA-01031: insufficient privileges 或: D:\Users\xiaomaimiao>sqlplus sys/lhr@192.168.1.31/orastrac...ERROR: ORA-01031: insufficient privileges 或: SQL> SELECT * FROM V$PWFILE_USERS;--为空 SQL> GRANT SYSDBA...Oracle的SYS用户登录报权限不足(ORA-01031: Insufficient Privileges)的常见原因有如下几个: ① 检查服务器端sqlnet.ora文件。...创建密码文件的命令为: Windows:orapwd file="E:\oracle\lhrdb\DATABASE\PWDortest.ORA" password=lhr Linux:orapwd file
ERROR: ORA-01031: insufficient privileges 这个步骤才开始验证参数文件,密码文件还没有开始做校验,为什么会抛出这个问题呢。...对于这个问题,还得从几个小的细节说起,一个就是操作系统认证,对于操作系统认证对于Windows和Linux,Unix都会有一些不同的设置,但是思路都是相通。...但是这个时候还是存在ORA-01031: insufficient privileges的问题,是修改的用户的问题没有解决彻底吗。...ERROR: ORA-01031: insufficient privileges 我继续想,是不是直接修改config.c就可以了,不需要再创建一个dba组了,行不行?...ERROR: ORA-01031: insufficient privileges 看起来一个很简单的问题,没有很快解决,看起来还是有些尴尬啊,不过知道了原委,发现这些东西还是需要好好理解。
statname n, v$sesstat t, v$session s * ERROR at line 2: ORA...-01031: insufficient privileges 但单独执行 SQL> select name, value from v$statname n, v$sesstat t, v$session...2)在不同schema下,即使有了查询权限,创建视图,还是会提示ORA-01031。
-01031: insufficient privileges SQL> alter system set optimizer_mode = first_rows_1; alter system set...optimizer_mode = first_rows_1 * ERROR at line 1: ORA-01031: insufficient privileges LOCKDOWN PROFILE...SQL> alter system checkpoint; alter system checkpoint * ERROR at line 1: ORA-01031: insufficient privileges...-29273: HTTP request failed ORA-01031: insufficient privileges ORA-06512: at "SYS.UTL_HTTP", line 380...ORA-06512: at "SYS.UTL_HTTP", line 1127 ORA-06512: at line 5
system :缺省密码为MANAGER,且被授予DBA角色 下面具体描述sys与system帐户 sys :这个帐户相当于SQL server中的sa帐户,或者说Xp系统中的administrator,或Linux...-01031: insufficient privileges RMAN> connect target sys/redhat@orcl --使用sys帐户连接成功 connected to target...-01031: insufficient privileges system@ORCL> conn / as sysdba Connected....-01031: insufficient privileges Warning: You are no longer connected to ORACLE....SQL> conn usr1/usr1@orcl as sysdba ERROR: ORA-01031: insufficient privileges SQL> conn usr1/usr1 as
is 'aa' * ERROR at line 1: ORA-01031: insufficient privileges LHR33@test18c>...-01031: insufficient privileges LHR33@test18c> conn / as sysdba Connected....is 'aa' * ERROR at line 1: ORA-01031: insufficient privileges LHR33@test18c>...LHR33@test18c> select * from lhr.bb; select * from lhr.bb * ERROR at line 1: ORA-01031...-01031: insufficient privileges LHR33@test18c> conn lhr/lhr Connected.
角色中存在sys用户,sysoper角色中存在system用户 二、Oracle的两种认证方式; 1.使用与操作系统集成的身份验证 2.使用Oracle数据库的密码文件进行身份认证 三、密码文件的位置 Linux...none : 表示关闭操作系统认证,只能密码认证 all : 用于linux或unix平台,关闭本机密码文件认证,采用操作系统认证,但远程可以使用密码文件认证 nts : 用于windows...ERROR: ORA-01031: insufficient privileges Enter user-name: ---------------------------------------...SQL> conn scott/tiger@orclas sysoper /*scott的sysop列为false*/ ERROR: ORA-01031: insufficient privileges...SQL> conn user1/user1@orclas sysdba ERROR: ORA-01031: insufficient privileges SQL> conn user1/user1as
杨大师(http://space.itpub.net/4227/viewspace-663069)介绍过TWO_TASK环境变量的作用,指出“在Unix和Linux环境下,可以设置TWO_TASK环境变量...bisal的监听: LSNRCTL> stop bisal 验证监听状态: [oracle@liu Desktop]$ tnsping bisal TNS Ping Utility for Linux...ERROR: ORA-01031: insufficient privileges Enter user-name: 禁止访问了。...4、当使用TWO_TASK环境变量时,操作系统验证登录数据库的方式被禁止,提示ORA-01031: insufficient privileges。...6、补充:tnsnames.ora文件默认采用的路径如下: $HOME(~)/.tnsnames.ora $TNS_ADMIN/tnsnames.ora /var/opt/oracle/tnsnames.ora
: ORA-01017: invalid username/password; logon denied Enter user-name: ERROR: ORA-01017: invalid username...-01031: insufficient privileges SQL> grant create table to test_data; Grant succeeded....增加用户在表空间的使用量限制: SQL> create table test (x int); create table test (x int) * ERROR at line 1: ORA...-01116: error in opening database file 7 ORA-01110: data file 7: '/opt/oracle/oradata/bisal/test_data..._02.dbf' ORA-27041: unable to open file Linux Error: 2: No such file or directory Additional information
DIAGNOSTICS_CONTROL初始化参数可以让你指定当一个未经授权的用户试图执行这些诊断操作时,数据库如何响应,可能的参数值是: ERROR: 当未经授权的用户尝试执行一个潜在的不安全的诊断操作时,该尝试以错误 ORA...-01031: 权限不足而失败。...此时,在新建立的用户 ENMO 上执行 ALTER SESSION 修改诊断参数,可以看到终端直接收到了 ORA-01031 错误,阻止了用户执行: SQL> connect enmo/enmo@enmo...SQL> ALTER SESSION SET EVENTS '1357 trace name context forever, level 2'; ERROR: ORA-01031: insufficient...privileges ORA-49100: Failed to process event statement [1357 trace name context forever, level 2]
ERROR: ORA-01045: user USER01 lacks CREATE SESSION privilege; logon denied Enter user-name: 此时需要赋予...connect权限给用户(原因见(2)),登陆后创建表提示01031错误: SQL> create table t(x number); create table t(x number) * ERROR...at line 1: ORA-01031: insufficient privileges 再次赋予resource权限给用户(原因见(2)),就可以创建表了。...删除用户: SQL> drop user user01; drop user user01 * ERROR at line 1: ORA-01922: CASCADE must be specified
普通用户对DBA_SOURCE视图进行闪回查询会报错:“ORA-01031: insufficient privileges”,如下所示: LHR10@orclasm > select * from...select * from dba_source as of timestamp sysdate -1/24 where rownum<=1 * ERROR at line 1: ORA...-01031: insufficient privileges 即使拥有DBA角色的用户也会报以上的错误。
execute createTS(‘nk_develop14061342’); 在行 28 上開始运行命令时出错: execute createTS(‘nk_develop14061343’) 错误报告: ORA...-01031: 权限不足 ORA-06512: 在 “NK_DEVELOP131021.CREATETS”, line 22 ORA-06512: 在 line 1 01031. 00000 –...int)’; end p_create_table; –然后測试 SQL> exec p_create_table; begin p_create_table; end; ORA...-01031: 权限不足 ORA-06512: 在”SUK.P_CREATE_TABLE”, line 3 ORA-06512: 在line 1 –能够看到。
建包失败 CREATE PACKAGE emp_bonus AS PROCEDURE show (hiredcnt int); END emp_bonus; / ERROR at line 1: ORA...-01031: insufficient privileges 3 只有编译权限 不支持单独给一个包编译权限:grant alter on emp_bonus to gm2; 正确写法:grant alter...END; END emp_bonus; / call emp_bonus.show(100); -- 给gm2编译权限 -- grant alter on emp_bonus to gm2; -- ORA...-01031: insufficient privileges gm2编译成功 alter package gm1.emp_bonus compile body; alter package gm1.emp_bonus...GM1@orcl11g>conn gm2/gm2 GM2@orcl11g>call gm1.emp_bonus.show(100); ORA-01031: insufficient privileges
sqlt := 'alter index ' || idx.index_name || ' rebuild online '; EXECUTE IMMEDIATE sqlt; 会报权限不足:如下 ORA...-01031: 权限不足 ORA-06512: 在"bdc.proc_rebuild_part_index", line 5 ORA-06512: 在line 1 既然提示说权限不足,所以问题的解决方法就是要赋予用户
-01031: insufficient privileges 排除role的影响 SQL> grant select on testo.mv to test; Grant succeeded....-01031: insufficient privileges SQL> revoke select on testo.mv from test; Revoke succeeded....: invalid input value MATERIALIZED VIEW for parameter OBJECT_TYPE in function GET_DDL ORA-06512: at "...SYS.DBMS_METADATA", line 3773 ORA-06512: at "SYS.DBMS_METADATA", line 3828 ORA-06512: at "SYS.DBMS_METADATA...", line 5678 ORA-06512: at line 1 生成报错, 确认了下,应该得改成MATERIALIZED_VIEW SQL> select dbms_metadata.get_ddl
ERROR: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER 3 sysdba对应的用户时SYS,而sysoper对应的用户...SQL> conn test/tets@test01 as sysdba ERROR: ORA-01031: insufficient privileges 5 关于sys,不得不提到密码文件...[ora11g@rac1 dbs]$ sqlplus sys/oracle@test01 as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Sat...ERROR: ORA-01031: insufficient privileges 创建了密码文件之后,就没有问题 [ora11g@rac1 dbs]$ orapwd password=oracle...file=orapwTEST01 entries=2 [ora11g@rac1 dbs]$ sqlplus sys/oracle@test01 as sysdba SQL*Plus: Release
My listener.ora file is below and my OS is XP Pro 2002 Service Pack 2....-dw # listener.ora Network Configuration File: C:\oracle\10.1.0\Db_1\network\admin\listener.ora # Generated
领取专属 10元无门槛券
手把手带您无忧上云