May 16, 2022 at 1:49 pm
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?
May 17, 2022 at 2:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
May 18, 2022 at 3:50 pm
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
May 24, 2022 at 9:30 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply