How to secure SQL scripts so that they cannot be seen by others but can only be executed.

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Create a view and give the permission for select only

rahul kiran

 Profile Answers by rahul kiran Questions by rahul kiran

• May 16th, 2009

Create a view and remove all the privilages except select on that view

Answer Question  Select Best Answer

How to call SQL script file from PL/SQL?

dj_dj_dj

 Profile Answers by dj_dj_dj Questions by dj_dj_dj

• Mar 18th, 2010

You can Call SQL Script by using @ and then giving path of the source fileFor ex: @c:/sqlscript.txt;RegardsDharmendra Jaiswal

prasadreddi

 Profile Answers by prasadreddi Questions by prasadreddi

• Mar 17th, 2010

@<path>filename.sqlgive the path where the file is located extactly.Ex :- Let us say our file is located at c:tempabc.sqlSQL> @"c:tempabc.sql" It is better practice to use double qu...

Answer Question  Select Best Answer