MS SQL Server - Block access to system objects & system stored procedure

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Block access to system objects & system stored procedure

Henry

2006-03-06, 7:23 am

Dear Sir/Madam,
Is there any convenience ways to block a list of users account from access
to system objects e.g. sysobjects, syscomments etc and disallow them to call
stored procedure e.g. sp_help etc.
My objective is to restrict the access to those applications account in
order to prevent hakers to knows the db schema e.g. thru SQL injection etc.
Many thanks!
Henry

Sponsored Links