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: object level permission

    1. Home  - 
    2. Posts tagged "object level permission"
    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
    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
    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 © 2025 | Powered by Neom