What security
features are available for stored procedures?
What security features are available for stored
procedures?
Answer
Database users can have permission to execute a stored procedure
without being granted permissions to access the database objects on which the
stored procedure operates.
Database users can be restricted from reading SQL command in the stored
procedure by encrypting it.
Sql server - What security features are
available for stored procedures? - Feb 11, 2010 at 11:55 AM by
Shuchi Gauri
What security features are available for
stored procedures?
Security features for stored procedures:
-
Grants users permissions to execute a
stored procedure irrespective of the related tables.
-
Grant users users permission to work with
a stored procedure to access a restricted set of data yet no give
them permissions to update or select underlying data.
-
Stored procedures can be granted execute
permissions rather than setting permissions on data
itself.
-
Provide more granular security control
through stored procedures rather than complete control on
underlying data in tables.
Also read
Stored procedures provide performance benefits through local
storage, precompiling the code, and caching................
Answer - The start and end of each
transaction......
Answer - It is created when CHECKPOINT statement
is executed.......
Answer - It is the process of organizing data into related table. To
normalize database, we divide database into
tables.....
Answer - Null means no entry has been made. It implies that the
value is either unknown or undefined.....
|