November 15, 2011 at 10:49 pm
Hi,
I have created a new database and created a new SQL user to access given only to this database. when i run below script, i came to know all that this user has access to other databases (which was migrated from SQL 2000 recently) through Guest user (even though the guest is disabled)
SELECT name, cast(has_dbaccess(name) as bit) FROM MASTER.SYS.DATABASES
When i checked the Guest properties of the database, DB_OWNER was assigned in database role membership. I am getting "login name must be specified (sqlmanagerUI)" error when i change any setting on the guest user.
How can i delete the guest permission?
November 16, 2011 at 12:13 am
Found the problem and fixed it.
When imported the database from 2000, the owner was different, that causing the issue.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply