Question : I’m trying to execute this script from Management Studio: GRANT ALTER ON ROLE::[AdaptTemplate] TO [AdaptAdmin] AS [AdminSapr] Execution […]
Category: Security
Ola Hallengren DatabaseBackup error on locating Windows directory
Question : Need help in resolving the issue with backing up a DB using Ola Hallengren’s stored procedure to a […]
how to script server side permissions – specifically EXECUTE ON SYS.XP_PROP_OLEDB_PROVIDER?
Question : I could not script the following server side permissions: GRANT VIEW DEFINITION ON LOGIN::[site_helpdesk] TO [Radhe] but thanks […]
Creating a User to access multiple databases
Question : Is it possible in SQL server to create a User without a Login that can access multiple databases? […]
How can I secure my database code?
Question : We have a lot of proprietary database code that is simply encrypted using the “WITH ENCRYPTION” option. Unfortunately, […]
How to set user-level security in 2007+ MS Access?
Question : I’ve read this MS info which should cover my problem. There are quite clear steps: Open the .mdb […]
MySQL server accessible from the internet nmap scan result
Question : I have a MySQL database on a server which is accessible from the internet and I’m doing some […]
SQL Server EXECUTE AS trouble
Question : I’m missing something while trying to make my stored procedure use EXECUTE AS. The stored procedure is reading […]
Permission for business logic layer & application
Question : I’m very new into db development and currently working on my first production app. I learned that I […]
RSExecRole missing
Question : I have multiple servers and 4 of them have reporting services installed with the ReportServer & ReportServerTempDB databases. […]