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: #drop user

    1. Home  - 
    2. Posts tagged "#drop user"
    3 Aug, 2020
    You cannot drop user because user 'testuser' owns grantable privileges and granted them to other users. 0 (0)
    Sybase ASE #drop user, #sp_dropuser, #sybase

    Error Description:

    Msg 17549, Level 16, State 1:
    Server 'SYB_ASE', Procedure 'sp_dropuser', Line 3:
    You cannot drop user because user 'testuser' owns grantable privileges and granted them to other users. The user has granted the following privileges:

    Resolution:

    Step1: … Read the rest

    2 Aug, 2020
    cannot drop user because user owns objects in database 0 (0)
    Sybase ASE #drop user, #object ownership

    Error Description:

    Msg 17545, Level 16, State 1:
    Server 'SYB_ASE', Procedure 'sp_dropuser', Line 267:
    You cannot drop user because user 'testuser' owns objects in database.

    Resolution:

    Step1: First find out uid of user

    1> select uid from sysusers where … 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