Skip to Content
24x7 Support
Email: mail@example.com
Call Us +(21) 1234 5678

    • Home
    • MSSQL
      • SQL On Linux
      • T-SQL Scripts
    • Sybase ASE
      • Sybase Scripts
    • Sybase Replication
    • Sybase IQ
    • Linux
    • Search for:

    Tag Archives: SQL Server database access

    1. Home  - 
    2. Posts tagged "SQL Server database access"
    3 Oct, 2022
    T-SQL Script to get user with DB OWNER role in SQL Server 0 (0)
    MSSQL db owner, SQL server, SQL Server database access

    Below query can be used to get all database users having db owner roles in SQL Server.

    DECLARE @dbname VARCHAR(50)   
    DECLARE @statement NVARCHAR(MAX)
    CREATE TABLE #UserPermission
    (
       ServerName SYSNAME,
       DbName SYSNAME,
       UserName SYSNAME,
       TypeOfLogIn VARCHAR(50),
       PermissionLevel VARCHAR(50),
       TypeOfRole VARCHAR(50)
    )
    
    … Read the rest
    21 Aug, 2021
    T-SQL script to check user access on multiple SQL databases 0 (0)
    MSSQL SQL on Linux, SQL Server database access

    Below query can be used to check user access on multiple databases in SQL Server.

    declare @UsrPerm_sql varchar(3000)
    declare @UsrPerm_table table ( ServerName varchar(200), DBName varchar(200), UserName varchar(250), LoginType varchar(500), DatabaseRole varchar(200))
    set @UsrPerm_sql='select @@servername, ''?'' as DBName,a.name as Name,a.type_desc 
    … Read the rest
    Recent Posts
    • SQL Server: T-SQL Script to find object level permission of specific table
    • SQL Server: T-SQL Script to find object level permission of user database
    • T-SQL Script to get user with DB OWNER role in SQL Server
    • T-SQL script to list all database user access in SQL Server
    • T-SQL script to find active processes in SQL Server

    Pages

    • About Me
    • Contact
    • Disclaimer
    • Privacy Policy

    Categories

    • Linux (8)
    • MSSQL (75)
      • SQL On Linux (15)
      • T-SQL Scripts (19)
    • Sybase ASE (26)
      • Sybase Scripts (1)
    • Sybase IQ (3)
    • Sybase Replication (27)
    • Uncategorized (1)

    Archives

    Copyright © 2026 | Powered by Neom