Not a useful note and more of a personal opinion then factual, but beyond the inventors of the Internet or any hardware has to be the following notion from IBM:
a 1976 research report by Lance A. ...
... Replication-filter-procedure
S = System base table
SN = Synonym
SQ = Service queue
TA = Assembly (CLR) DML trigger
TF = SQL table-valued-function
TR = SQL DML trigger
TT = Table type
U = Table ...
... PUBLIC SYNONYM sp_get_studentdetails_from_ad FOR base_table_owner.sp_get_studentdetails_from_ad;
GRANT EXECUTE ON sp_get_studentdetails_from_ad TO my_ssrs_user;
Notes:
No "SELECT ... INTO ..." on ...
... sac180786.txt
Permissions
CREATE PUBLIC SYNONYM sp_get_studentdetails_from_ad FOR base_table_owner.sp_get_studentdetails_from_ad;
GRANT EXECUTE ON sp_get_studentdetails_from_ad ...
What?
I need to refer to how to create a function in Oracle PL/SQL and sites on the net just attempt to overcomplicate everything and have forgotten how it is to be new to Oracle. I need a function ...
... an article on this so please refer to SSRS Parameters in Oracle Stored Procedure.
Oracle: Grant another user permissions
/* on the table: ssrs_audit_table */
CREATE OR REPLACE PUBLIC SYNONYM ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.