如果想要加上在navicat上有没有权限,这个时候就应该到本地cmd终端中进行权限的添加、
具体的 *** 作:
1. 可以进入数据库,但无update权限:
*** 作过程:在WINDOWS的DOS窗口下,进入MYSQL安装目录的BIN目录,
运行mysqld-nt --skip-grant-tables,当前窗口将会停止。
另外打开一个命令行窗口,执行mysql 如果提示没有这个命令,先进入MYSQL的安装位置下BIN目录再运行mysql
>use mysql
>update user set Update_priv ='Y' where user = 'root'
如果root 没有所有数据的权限
更新的MYSQL.USER表的所有字段中为N的为Y就可以了。
update user set Select_priv ='Y' where user = 'root'
update user set Insert_priv ='Y' where user = 'root'
update user set Update_priv ='Y' where user = 'root'
update user set Delete_priv ='Y' where user = 'root'
update user set Create_priv ='Y' where user = 'root'
update user set Drop_priv ='Y' where user = 'root'
update user set Reload_priv ='Y' where user = 'root'
update user set Shutdown_priv ='Y' where user = 'root'
update user set Process_priv ='Y' where user = 'root'
update user set File_priv ='Y' where user = 'root'
update user set Grant_priv ='Y' where user = 'root'
update user set References_priv ='Y' where user = 'root'
update user set Index_priv ='Y' where user = 'root'
update user set Alter_priv ='Y' where user = 'root'
update user set Show_db_priv ='Y' where user = 'root'
update user set Super_priv ='Y' where user = 'root'
update user set Create_tmp_table_priv ='Y' where user = 'root'
update user set Lock_tables_priv ='Y' where user = 'root'
update user set Execute_priv ='Y' where user = 'root'
update user set Repl_slave_priv ='Y' where user = 'root'
update user set Repl_client_priv ='Y' where user = 'root'
update user set Create_view_priv ='Y' where user = 'root'
update user set Show_view_priv ='Y' where user = 'root'
update user set Create_routine_priv ='Y' where user = 'root'
update user set Alter_routine_priv ='Y' where user = 'root'
update user set Create_user_priv ='Y' where user = 'root'
update user set Event_priv ='Y' where user = 'root'
update user set Trigger_priv ='Y' where user = 'root'
问题:
ORA-01031: 权限不足
解决:
grant select any table to TSS_TEST
我把inittest.ora这个pfile文件cp了一份,init1.ora,然后用sqlplus登录,连接以后,startup pfile=$ORACLE_HOME/dbs/init1.ora这样就可以启动数据库了,于是我想,肯定是spfile文件被改动了,因为我指定用init1.ora这个文件可以启动啊,所以,我cp init1.ora inittest.ora ,然后再用sqlplus登录,连接后create spfile from pfile成功后,在startup就OK 了。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)