| DBA_ROLE_PRIVS [message #443202] |
Sat, 13 February 2010 11:03  |
rkgoyal98
Messages: 39
Registered: October 2009
|
Member |
|
|
While upgrading 6i Application, in one of the form designed for granting/revoking roles the following cursor is raising Exception ORA-00942 ( Table or View Does not Exist)
Running the same Query in SQL navigator logged on as same user the result is correctly displayed
SELECT GRANTED_ROLE,'Y' ISGRANTED FROM DBA_ROLE_PRIVS WHERE DEFAULT_ROLE='YES' AND GRANTEE =:UNAME
UNION ALL
SELECT GRANTED_ROLE,'Y' ISGRANTED FROM DBA_ROLE_PRIVS WHERE DEFAULT_ROLE='NO' AND GRANTEE = :UNAME
UNION ALL
SELECT CODE GRANTED_ROLE,'N' ISGRANTED FROM PRMAGEC WHERE CODETYPE='RO' AND CODELENGTH IS NULL
AND CODE NOT IN
(SELECT DISTINCT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE DEFAULT_ROLE='YES' AND GRANTEE = :UNAME
UNION ALL
SELECT DISTINCT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE DEFAULT_ROLE='NO' AND GRANTEE = :UNAME )
ORDER BY 1;
What can be reason for the error and what are possible solutions
Regards
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
