Question : So I created an account, gave him dbcreator and securityadmin privileges and then through that account tried to […]
Tag: permissions
SQL server Service Accounts permission
Question : I will be changing the existing SQL Server Service accounts from the default to Domain accounts from the […]
How to check who has permission to execute a stored procedure?
Question : I have two environments/servers. Each has two databases, say DATABASE_A and DATABASE_B. There is a stored procedure in […]
MySQL – admin user is able to change password of the super user
Question : I am new to MySQL administration and hence this question – I wanted to create a MySQL admin […]
MS SQL Server 2016 – Database Security – Login Permissions
Question : I have an SQL Server 2016 database with Always On structure. I have a login that I called […]
Can I trust the effective permissions of default database roles?
Question : I’ve granted membership in the db_datareader and db_datawriter roles for some testing being performed by a specific user. […]
Organizing and assigning privileges to multiple objects in MySQL
Question : I’m new to MySQL, moving from MS SQL Server, and I’m wondering if there’s a way to logically […]
MongoDB RBAC to only one document
Question : Is it possible to give access to a user to only one document in a collection which is […]
Collation conflict when running dynamic sql FOR XML PATH
Question : I am getting the following error message when running the query below: Cannot resolve the collation conflict between […]
Select data from another database instance on the same server in sql server
Question : I have a query shown below: select count(*) as Count, datepart(yyyy, [LogDate]) as [Year] from ViewAssociate..Auth_Log where ActionCode […]