Ora-01045 Error
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on
What Is Create Session Privilege
and reload this page. Please enter a title. You can not create session privilege in oracle 11g post a blank message. Please type your message and try again. More discussions in General Database
Create Table Insufficient Privileges Oracle
Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 8 Replies Latest reply on Oct 12, 2013 9:35 AM by 44a085df-2c25-40a8-8a81-6727b1749e45 ORA-01045: user lacks CREATE SESSION privilege; oracle grant create table logon denied(10.2.0.5) 499760 Dec 4, 2010 10:37 AM Hi , I am getting the following error while connecting: ORA-01045: user ABC lacks CREATE SESSION privilege; logon denied even after granting CONNECT and RESOURCE this error is coming. My database version is 10.2.0.5 and OS is RHEL5. Is this a bug? Regards, Kumar I have the grant all privileges to user in oracle same question Show 0 Likes(0) 94568Views Tags: none (add) This content has been marked as final. Show 8 replies 1. Re: ORA-01045: user lacks CREATE SESSION privilege; logon denied(10.2.0.5) Centinul Dec 4, 2010 11:09 AM (in response to 499760) Post the results of the following queries: SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE='ABC'; SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE='ABC'; Like Show 0 Likes(0) Actions 2. Re: ORA-01045: user lacks CREATE SESSION privilege; logon denied(10.2.0.5) 695836 Dec 4, 2010 11:09 AM (in response to 499760) Hi, CONNECT role might not be active in users' session. Grant it manually as: SQL> grant create session to ABC; Like Show 2 Likes(2) Actions 3. Re: ORA-01045: user lacks CREATE SESSION privilege; logon denied(10.2.0.5) 499760 Dec 4, 2010 12:01 PM (in response to Centinul) SQL> set lines 1000 SQL> SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE='ABC '; GRANTEE PRIVILEGE ADMIN_OPT ------------------------------ ---------------------------------------- --------- ABC UNLIMITED TABLESPACE NO SQL> SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE='ABC '; GRANTEE GRANTED_ROLE ADMIN_OPT DEFAULT_R ----------------------------------------
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life Cycles
Oracle Insufficient Privileges
Manage Cases Request Case Start Chat Back to results sp2-0640 not connected Print Share Is This Content Helpful? Search on GeoNet Submit to ArcGIS Ideas Error:
Grant Create Table To User
ORA-01045: user GUEST lacks CREATE SESSION privilege Error Message C:\>sdelayer -o describe -u guest -p guest ArcSDE 8.0.1 Layer Administration Utility ----------------------------------------------------- https://community.oracle.com/thread/2141972 Error: Underlying DBMS error (-51). Error: Could not create a connection. Extended DBMS error code: 1045 ORA-01045: user GUEST lacks CREATE SESSION privilege; logon denied Cause The Oracle user lacks the CONNECT role.Note: the CONNECT role consists of several privileges, one of which is CREATE SESSION. http://support.esri.com/technical-article/000002254 Solution or Workaround Grant the CONNECT role to the Oracle user. For example, the sdelayer command (above) will run successfully after the Oracle user named 'guest' is granted the CONNECT role. Created: 5/5/2016 Last Modified: 5/5/2016 Article ID: 000002254 Software: ArcSDE 3.0, 3.0.1, 3.0.2, 3.0.2.1, 3.0.2.2, 8.0.1, 8.0.2, 8.1 Is This Content Helpful? Is This Content Helpful? Yes No We're glad to know this article was helpful. How can we make this better? Submit Contact our Support Team Request Case Start Chat Questions or issues with the site? Send Feedback Privacy Contact Support USA +1-888-377-4575 Name Email URL Please rate your online support experience with Esri's Support website.* Poor Below Satisified Satisfied Above Satisfied Excellent What issues are you having with the site? How can we improve? Submit Feedback sent successfully. Error while sending mail. Loading
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us http://stackoverflow.com/questions/22995386/why-doesnt-oracle-think-my-user-has-the-create-session-privilege-when-i-try-t Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Why doesn't Oracle think my user has the create table “Create Session” privilege when I try to connect? up vote 2 down vote favorite 1 I've created a role in my Oracle 11g database called TestUserRole that will eventually have more privileges, but currently has only the Create Session privilege. I've assigned that role to a user, TestUser. It is their only role. I created this as follows: CREATE ROLE TestUserRole IDENTIFIED BY somepassword; GRANT Create Session create session privilege TO TestUserRole; CREATE USER TestUser IDENTIFIED BY somepassword; GRANT TestUserRole TO TestUser; When I try to connect to the database, I receive: ORA-01045: user TESTUSER lacks CREATE SESSION privilege; logon denied I have verified (I think) that the user and role were setup successfully. If I query select * from dba_role_privs where grantee = 'TESTUSER' I get | Grantee | Granted_Role | Admin_Option | Default_Role | --------------------------------------------------------- | TESTUSER | TESTUSERROLE | NO | YES | Then if I query select * from role_sys_privs where role = 'TESTUSERROLE' I get | Role | Privilege | Admin_Option | ------------------------------------------------ | TESTUSERROLE | CREATE SESSION | NO | So it appears that I have created the user and role successfully, the user has the role, and the role has the create session permission. Yet, when I try to log on, Oracle is telling me that the user doesn't have the Create Session permission. Where am I going wrong? Do I have to assign this privilege directly to the user rather than through a role? oracle roles share|improve this question asked Apr 10 '14 at 17:48 Sterno 860821 add a comment| 1 Answer 1 active oldest votes up vote 9 down