- 使用新创建的用户登录连接,用户名:LOCALDB 密码:root 报错
- 原因:是由于创建用户时未分配权限给新用户
- 解决办法:执行如下语句
grant create session,resource to LOCALDB ;
关注
码龄 粉丝数 原力等级 --
- 被采纳
- 被点赞
- 采纳率

已结题
ORA-01045: user LOCALDB lacks CREATE SESSION privilege;
收起
- 写回答
- 好问题 0 提建议
- 关注问题
微信扫一扫
点击复制链接分享
- 邀请回答
- 编辑 收藏 删除
- 收藏 举报
0条回答 默认 最新
报告相同问题?
提交
- 2016-03-02 21:46badman250的博客 ORA-29250: Invalid index specifed in call to dbms_sql.bind_array Cause: An invalid index was specified in a call to bind_array of dbms_sql. The index may have been null or of an improper value. Act
- 2016-03-02 21:42badman250的博客 ORA-19500: device block size string is invalid Cause: the device block size returned by sequential I/O OSD is invalid Action: If the block size was set by using the PARMS option of the Recovery Man
- 2013-03-02 10:43冰释镜湖的博客 与 Data Pump 权限相关的错误及解决办法: 示例语句: > expdp scott/tiger DIRECTORY=my_dir DUMPFILE=exp_s.dmp \ LOGFILE=exp_s.log SCHEMAS=scott ...UDE-00008: operation generated ORACLE ...ORA-0104
- 2016-03-02 21:40badman250的博客 ORA-12500: TNS:listener failed to start a dedicated server process Cause: The process of starting up a dedicated server process failed. The executable could not be found or the environment may be se
- 2017-03-13 10:52dba_monkey的博客 常见错误: -60 ORA00060: deadlock detected while waiting for resource 一般错误: - 1 ORA00001: unique constraint (.) ... -17 ORA00017: session requested to set trace event -18 ORA00018: maximu
- 2019-11-11 17:22马克力的博客 ORA_ERROR大全 1 ORA00001: unique constraint (.) ...-17 ORA00017: session requested to set trace event -18 ORA00018: maximum number of sessions exceeded -19 ORA00019: maximum number of session lic...
- 2012-07-16 16:43cppg67031的博客 me too! . . exported "ZNJL"."S_WL_STD_FACTOR" 0 KB 0 rows ORA-39125: Worker unexpected fatal ...
- 2017-02-17 08:59debimeng的博客 1、ORA-12560: TNS: 协议适配器错误 场景:在cmd窗口输入:sqlplus "/as sysdba"想打开数据库时报的错; 原因:没有启动Oracle服务器; 解决:WIN+R,跳出运行窗口,输入"services.msc",打开服务窗口;...
- 2016-03-02 21:30badman250的博客 ORA-04930 to ORA-07499 6 ORA-04930: open sequence number failed or initial state is valid Cause: Either Shared Sequence Number OS component was not installed properly, or an MC hardware failure may
- 2013-03-19 00:48weixin_30435261的博客 有网友提问在使用expdp时出现了ORA-39125、ORA-31642错误,具体错误信息如下: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining ...
- 2010-06-29 00:31firecityplans的博客 ORA-29250: Invalid index specifed in call to dbms_sql.bind_arrayCause: An invalid index was specified in a call to bind_array of dbms_sql. The index may have been null or of an improper value.Action: ...
- 2019-09-27 23:31久违的太阳的博客 ORA-01045: user C##SUQ lacks CREATE SESSION privilege; logon denied Warning: You are no longer connected to ORACLE. 如果我们在CDB中赋予了c##suq登录权限,他就可以登录到...
- 2014-02-24 18:21kuifeng.dong的博客 ORA-24312 illegal parameters specified for allocating user memory Cause: An illegal size or null pointer was specified for user memory. Action: Specify a legal size and a valid pointer ...
- 2014-02-24 18:14kuifeng.dong的博客 lacks CREATE SESSION privilege in database link (linkname string ) Cause: There are several possible causes for this message: First, you will get this message if your username in the second ...
- 2020-02-16 15:05想干什么就干什么的博客 create user lky identified by 123456; 再次执行SQL> alter session set "_ORACLE_SCRIPT"=true; 这个需要执行两遍 grant connect, resource,dba to lky; 为用户授权: 授权命令语法: ...
- 没有解决我的问题, 去提问