database access Archives -

10 Oct, 2022

SQL Server: T-SQL Script to find object level permission of specific table 0 (0)

MSSQL, T-SQL Scripts database access, SQL server, table level permission

Below query can be used to find object level permission of specific table in SQL Server.

use <DB-- replace database name here
go
select @@servername as Server, db_name() as 'Database', su.name as 'UserName', so.name as Object, permission_name as Permission

… Read the rest

7 Oct, 2022

SQL Server: T-SQL Script to find object level permission of user database 0 (0)

MSSQL, T-SQL Scripts database access, object level permission, SQL server, table level permission, TSQL

Below query can be used to find object level permission of user database in SQL Server.

use <DB-- replace database name here
go
select @@servername as Server, db_name() as 'Database', su.name as 'UserName', so.name as Object, permission_name as Permission

… Read the rest

3 Oct, 2022

T-SQL script to list all database user access in SQL Server 0 (0)

MSSQL database access, SQL server

25 Sep, 2022

SQL Server: T-SQL Script to find object level permission for specific user 5 (1)

MSSQL, T-SQL Scripts database access, object level permission, SQL server, table level permission, TSQL

Below query can be used to find object level permission for specific user in SQL Server database.

use <DB-- replace database name here
go
select @@servername as Server, db_name() as 'Database', su.name as 'UserName', so.name as Object, permission_name as

… Read the rest

Tag Archives: database access

SQL Server: T-SQL Script to find object level permission of specific table 0 (0)

SQL Server: T-SQL Script to find object level permission of user database 0 (0)

T-SQL script to list all database user access in SQL Server 0 (0)

SQL Server: T-SQL Script to find object level permission for specific user 5 (1)