Home » SQL & PL/SQL » SQL & PL/SQL » synonym and permission
synonym and permission [message #594539] Thu, 29 August 2013 15:24 Go to next message
Messages: 82
Registered: August 2013
new to oralce, We have created a view in oralce database.

and grant select to public. Does this mean it can be used by any user to select from it?

Also in our build script, I see we have a file creating synonym, it seems every time we create a new custom view or function we need to add that in the file:

create or replace public synonym daily_attendance for ps.daily_attendance,

grant select on daily_attendance to public;

Why we need to do this? does the second grant select is the same as we did earlier?

Re: synonym and permission [message #594555 is a reply to message #594539] Fri, 30 August 2013 00:25 Go to previous message
Messages: 1848
Registered: November 2006
Senior Member
Fortunately, some kind guys from Oracle already took an effort to describe the features which are provided in their database.
Books containing this kind of information are called documentation and they are available e.g. online on http://tahiti.oracle.com/

You should start with Concepts book.
For 11gR2 (it is always beneficial to state your Oracle version), the relevant chapter about synonyms is placed here: http://docs.oracle.com/cd/E11882_01/server.112/e40540/schemaob.htm#i5669
Previous Topic: Value of first and last sale
Next Topic: compare prev records with current
Goto Forum:

Current Time: Mon Aug 21 20:51:07 CDT 2017

Total time taken to generate the page: 0.10861 seconds