Home » RDBMS Server » Security » IB_ENCODEDATE
IB_ENCODEDATE [message #258681] Mon, 13 August 2007 06:21 Go to next message
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 #258685 is a reply to message #258681] Mon, 13 August 2007 06:27 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Insufficient information. Give more info.
Re: IB_ENCODEDATE [message #258738 is a reply to message #258685] Mon, 13 August 2007 08:49 Go to previous messageGo to next message
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??
Re: IB_ENCODEDATE [message #258824 is a reply to message #258738] Mon, 13 August 2007 11:21 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Grant function related privleges to the use and then try.

http://techonthenet.com/oracle/grant_revoke.php

[Updated on: Mon, 13 August 2007 11:22]

Report message to a moderator

Re: IB_ENCODEDATE [message #259011 is a reply to message #258824] Tue, 14 August 2007 02:27 Go to previous message
tezkatlipoka
Messages: 3
Registered: August 2007
Junior Member
sorry, I dont understand, function is granted, but not working. I think IB_ENCODEDATE has dependencies to "I dont know what"
Previous Topic: Password file (merged)
Next Topic: how decrypt oracle user's password
Goto Forum:
  


Current Time: Thu Dec 08 20:08:23 CST 2016

Total time taken to generate the page: 0.05140 seconds