| IB_ENCODEDATE [message #258681] |
Mon, 13 August 2007 06:21  |
tezkatlipoka
Messages: 3
Registered: August 2007
|
Junior Member |
|
|
Hi, I have problem with user settings on my Oracle 10g database. I need to create a new restricted user. Some select for a few tables, this is not problem; but I have a problem with the "IB_ENCODEDATE" right - I granted the "IB_ENCODEDATE execute" right, but the query is still with "ERROR at line 1:
ORA-00904: "IB_ENCODEDATE": invalid identifier". What can I do to fix it?
|
|
|
|
|
|
| Re: IB_ENCODEDATE [message #258738 is a reply to message #258685] |
Mon, 13 August 2007 08:49  |
tezkatlipoka
Messages: 3
Registered: August 2007
|
Junior Member |
|
|
Tell me which info do you need.
I have 5 users, schemas and tablespaces. I need new user, restricted, only with access for a few tables (Only selects). So I have one user, with connect role, and few selects in "Object Privileges", it is working. But in one select I have IB_ENCODEDATE funtion (.........and II.DueDate$Date < IB_EncodeDate(to_char(SYSDATE, 'YYYY'),to_char(SYSDATE, 'MM'),to_char(SYSDATE, 'DD')) and........). If I am connect as one of normal user, it is working, but if I am as restricted user it is with error (see 1th report). I tried grant "dba" to restricted user (only for test) and it is still not working. What is neccessary to do, or to grant for use IB_ENCODEDATE function??
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
