PBALP User in SQL Server

  • Hi Everyone,

    Currently looking at tidying up some SQL servers and i have a number of local users (PBALP) being one of them i would like to drop. Is there a way i can check to see what if anything is dependant on that user?

     

     

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • To get this question unstuck, please clarify "local user" as that is not a technical name for a user in SQL.

    Database users can be created without a login, for a certificate, or for a asymmetric key.  A user may also be created when the user creates an object in the database and does not have the default schema=dbo, in this case there would be a PBALP schema.

    Use this query to get more information about the users:

    select * from sys.database_principals

    From an administrative perspective, it is best to leave it alone if the user is not related to a login.  Deleting users should only be done if the application can be fully tested in a lower environment first.

    --Will

  • This was removed by the editor as SPAM

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply