Import of 10.1.0.5 into 11.1 or 11.2 does not retain the privileges of any account
Last updated on FEBRUARY 10, 2011
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 184.108.40.206.0 - Release: 10.2 to 11.2
Information in this document applies to any platform.
1. The following error is reported when trying to access the account:
SQL*Plus: Release 220.127.116.11.0 Production on Fri Dec 11 10:09:21 2009
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: bdai
ORA-01045: user BDAI lacks CREATE SESSION privilege; logon denied
BDAI had the following roles assigned to her:
Role Admin Option Default
CMS_WASTE_ACCUM N Y
CTS_UPDATE N N
CTS_VIEW N Y
MSDS_UPDATE N N
MSDS_VIEW N Y
The CTS_VIEW role which is a default role has the following:
At the lowest level, END_USER has the following system privileges assigned to it:
So the question is, if end_user has create session and end_user is assigned to CTS-VIEW which is a default role assigned to bdai, why does a sqlplus session to the oracle 11 database as bdai generate the "ORA-01045: user BDAI lacks CREATE SESSION privilege; logon denied" error?
As a side note, in the Oracle 10g database, created a new account bdai and this account is identical to bdai, and yet, it is able to log on to the new Oracle 18.104.22.168 database.
The export of 10.1.0.5 database and import it into a second 10.1.0.5 database, all of the privileges are preseved for each account. The export of 10.1.0.5 database and import it into an 22.214.171.124 or 126.96.36.199 database, all of the privileges are ignored. They appear to be assigned but are not recognized.
Also tried using dbua, reported with the same results. Granting select any priveleges nothing. The table is real and has data. The user has select access to the table and can't access the table.
Tried to migrate the database from 10g to 11g R1 and R2
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms