我是oracle菜鸟,昨天安装了一个805的数据库,建立了一个用户。今天用sys登录以后,要给这个用户sysdba权限,但是我输入grant sysdba to username;以后,系统会提示
grant sysdba to username
*
ERROR 位于第1行
ORA-01031: insufficient privileges请问各位大虾这是什么问题,谢谢。
grant sysdba to username
*
ERROR 位于第1行
ORA-01031: insufficient privileges请问各位大虾这是什么问题,谢谢。
connect / as sysdba;
再
grant dba to username;
connect / as sysdba;
再
grant dba to username;
你的SYS用户没有SYSDBA的权限 所以会报这个
sqlplus /nolog;
connect / as sysdba;
grant dba to username;
sqlplus sys/pwd@host:port/sid / as sysdba
如:
sqlplus sys/123456@//192.168.0.2:1521/orcl / as sysdba 或
sqlplus sys/123456@mypc:1521/orcl / as sysdba
如果数据库就在当地,也可以使用
sqlplus / as sysdba
它使用本地操作系统身份验证
如还不清楚,可以使用
sqlplus -h
查看帮助另附:
在sqlplus里的connect命令的语法同上
SPOOL d:\temp\00、建立用户.log
REM 创建用户 用户名为 jy 口令jy0520PROMPT
PROMPT 请以用户 SYSTEM登录
PROMPT
rem ACCEPT INPASS prompt '请输入SYSTEM的密码 : ' hide
rem ACCEPT Connect_Str prompt '联接的ORACLE数据库是 (e.g. t:node:SID) [LOCAL] : '
PROMPTrem CONNECT SYSTEM/&INPASS@&Connect_Strrem WHENEVER sqlerror exitrem ACCEPT uname char prompt '用户:';
rem ACCEPT pname char prompt '密码:';
rem SET verify off;CREATE USER jy IDENTIFIED BY jy0520 DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;GRANT ALTER ANY CLUSTER TO jy;
GRANT ALTER ANY INDEX TO jy;
GRANT ALTER ANY PROCEDURE TO jy;
GRANT ALTER ANY ROLE TO jy;
GRANT ALTER ANY SEQUENCE TO jy;
GRANT ALTER ANY SNAPSHOT TO jy;
GRANT ALTER ANY TABLE TO jy;
GRANT ALTER ANY TRIGGER TO jy;
GRANT ALTER DATABASE TO jy;
GRANT ALTER PROFILE TO jy;
GRANT ALTER RESOURCE COST TO jy;
GRANT ALTER ROLLBACK SEGMENT TO jy;
GRANT ALTER SESSION TO jy;
GRANT ALTER SYSTEM TO jy;
GRANT ALTER TABLESPACE TO jy;
GRANT ALTER USER TO jy;
GRANT ANALYZE ANY TO jy;
GRANT AUDIT SYSTEM TO jy;
GRANT BACKUP ANY TABLE TO jy;
GRANT BECOME USER TO jy;
GRANT COMMENT ANY TABLE TO jy;
GRANT CONNECT TO jy;
GRANT CREATE ANY CLUSTER TO jy;
GRANT CREATE ANY INDEX TO jy;
GRANT CREATE ANY PROCEDURE TO jy;
GRANT CREATE ANY SEQUENCE TO jy;
GRANT CREATE ANY SNAPSHOT TO jy;
GRANT CREATE ANY SYNONYM TO jy;
GRANT CREATE ANY TABLE TO jy;
GRANT CREATE ANY TRIGGER TO jy;
GRANT CREATE ANY VIEW TO jy;
GRANT CREATE CLUSTER TO jy;
GRANT CREATE DATABASE LINK TO jy;
GRANT CREATE PROCEDURE TO jy;
GRANT CREATE PROFILE TO jy;
GRANT CREATE PUBLIC DATABASE LINK TO jy;
GRANT CREATE PUBLIC SYNONYM TO jy;
GRANT CREATE ROLE TO jy;
GRANT CREATE ROLLBACK SEGMENT TO jy;
GRANT CREATE SEQUENCE TO jy;
GRANT CREATE SESSION TO jy;
GRANT CREATE SNAPSHOT TO jy;
GRANT CREATE SYNONYM TO jy;
GRANT CREATE TABLE TO jy;
GRANT CREATE TABLESPACE TO jy;
GRANT CREATE TRIGGER TO jy;
GRANT CREATE USER TO jy;
GRANT CREATE VIEW TO jy;
GRANT DBA TO jy;
GRANT DELETE ANY TABLE TO jy;
GRANT DROP ANY CLUSTER TO jy;
GRANT DROP ANY INDEX TO jy;
GRANT DROP ANY PROCEDURE TO jy;
GRANT DROP ANY ROLE TO jy;
GRANT DROP ANY SEQUENCE TO jy;
GRANT DROP ANY SNAPSHOT TO jy;
GRANT DROP ANY SYNONYM TO jy;
GRANT DROP ANY TABLE TO jy;
GRANT DROP ANY TRIGGER TO jy;
GRANT DROP ANY VIEW TO jy;
GRANT DROP PROFILE TO jy;
GRANT DROP PUBLIC DATABASE LINK TO jy;
GRANT DROP PUBLIC SYNONYM TO jy;
GRANT DROP ROLLBACK SEGMENT TO jy;
GRANT DROP TABLESPACE TO jy;
GRANT DROP USER TO jy;
GRANT EXECUTE ANY PROCEDURE TO jy;
GRANT EXP_FULL_DATABASE TO jy;
GRANT FORCE ANY TRANSACTION TO jy;
GRANT FORCE TRANSACTION TO jy;
GRANT GRANT ANY PRIVILEGE TO jy;
GRANT GRANT ANY ROLE TO jy;
GRANT IMP_FULL_DATABASE TO jy;
GRANT INSERT ANY TABLE TO jy;
GRANT LOCK ANY TABLE TO jy;
GRANT MANAGE TABLESPACE TO jy;
GRANT RESOURCE TO jy;
GRANT SELECT ANY SEQUENCE TO jy;
GRANT SELECT ANY TABLE TO jy;
GRANT UNLIMITED TABLESPACE TO jy;
GRANT UPDATE ANY TABLE TO jy;spool off;结贴去了~~