ORA-00904: : invalid identifier in oracle 11G [message #596525] |
Tue, 24 September 2013 06:12 |
|
manojkakkar@gmail.com
Messages: 1 Registered: September 2013
|
Junior Member |
|
|
Hi,
I have created one user in DB using below command
SQL> create user user1 identified by user1;
User created.
SQL> grant dba to user1;
Grant succeeded.
SQL>
I am trying to run below query
SQL> select dbms_random.value(-9223372036854775808, 9223372036854775807) from dual;
select dbms_random.value(-9223372036854775808, 9223372036854775807) from dual
*
ERROR at line 1:
ORA-00904: : invalid identifier
SQL>
Problem :- I am getting "ORA-00904: : invalid identifier" even after giving the DBA right to user.
When I run the same query using the sysdba , I am able to run the query
SQL> conn / as sysdba
Connected.
SQL> select dbms_random.value(-9223372036854775808, 9223372036854775807) from dual;
DBMS_RANDOM.VALUE(-9223372036854775808,9223372036854775807)
-----------------------------------------------------------
-5.113E+18
SQL>
. Please help me to get the issue solve.
|
|
|
|
|
|
Re: ORA-00904: : invalid identifier in oracle 11G [message #597367 is a reply to message #596525] |
Thu, 03 October 2013 17:27 |
Solomon Yakobson
Messages: 3269 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
manojkakkar@gmail.com wrote on Tue, 24 September 2013 07:12Please help me to get the issue solve.
I suggest you contact DBA. By default procedural option creates DBMS_RANDOM package, a public synonym DBMS_RANDOM and grants execute to public. So, unless public synonym/execute to public was removed on purpose, what you are experiencing might indicate there were issues creating database.
SY.
|
|
|