Home » SQL & PL/SQL » SQL & PL/SQL » ora-01720 (Oracle 9i,windows)
ora-01720 [message #354016] Thu, 16 October 2008 01:40 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Hi all,

i have database 'A'with 2 main users 'c' & 'd'. In that i am getting error "ora-01720 grant option does not exist for 'string" when i try to grant 'select privilege' to the view.

Even i checked the dependent objects (2 table) of that view and granted the required privilege (select) to the tables but still i am getting the same error.

Kindly revert me with the solution

Regards,
Balaji

[Updated on: Thu, 16 October 2008 01:42]

Report message to a moderator

Re: ora-01720 [message #354017 is a reply to message #354016] Thu, 16 October 2008 02:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use SQL*Plus and copy and paste your session.

read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Kindly follow the guidelines.

Regards
Michel

[Updated on: Thu, 16 October 2008 02:10]

Report message to a moderator

Re: ora-01720 [message #354026 is a reply to message #354016] Thu, 16 October 2008 02:51 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
We need to see what the command you're trying to execute is before we can be much help.

Based on what you wrote, it's possible that you've got things quite badly wrong - you can't grant a SELECT privilege to a View, only to a user.
Re: ora-01720 [message #354193 is a reply to message #354026] Thu, 16 October 2008 22:39 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

we can grant a select privilege on a view to user.I have tried it and ultimately it also worked fine .

Regards,
Re: ora-01720 [message #354234 is a reply to message #354193] Fri, 17 October 2008 02:29 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Indeed you can grant SELECT priviliges ON a view.
What you can't do is what you said in your original post, which is:
Quote:
grant 'select privilege' to the view


Now, rather than playing semantic games, why don't you show us the SQL that you used, and the error that you got, and we'll see if we can work out what went wrong.
Re: ora-01720 [message #354307 is a reply to message #354234] Fri, 17 October 2008 09:43 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

it is grant 'select privilege' on view to user and not grant select privilege to view.

Solution is need to give required privilege to the underlying objects of the view and then grant the select privilege on view to user. finally it worked .


I am not playing any semantic games here.May be my sentence would be wrong .

Regards,
Balaji

Previous Topic: Use SUBSTR to get 3rd position with _ delimeter
Next Topic: fill missing values
Goto Forum:
  


Current Time: Thu Dec 08 18:39:51 CST 2016

Total time taken to generate the page: 0.09139 seconds