features are available for stored procedures?
What security features are available for stored
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
What security features are available for
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
Provide more granular security control
through stored procedures rather than complete control on
underlying data in tables.
Stored procedures provide performance benefits through local
storage, precompiling the code, and caching................
Answer - The start and end of each
Answer - It is created when CHECKPOINT statement
Answer - It is the process of organizing data into related table. To
normalize database, we divide database into
Answer - Null means no entry has been made. It implies that the
value is either unknown or undefined.....