public role
-
How is it possible to modify a user in the pubblic role, after restoring a database. Restoring a db, in the new one i find in the public role the users that there was in the old one. I need to keep one of it out?
tks
-
The public role includes every user who has access to the database. This cannot be undone. Don't grant the user access to the database and the user won't have access to whatever public has access to. BTW, assigning permissions to public is generally frowned upon because of this reason.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley -
Hi Brian,
quote:
The public role includes every user who has access to the database. This cannot be undone. Don't grant the user access to the database and the user won't have access to whatever public has access to. BTW, assigning permissions to public is generally frowned upon because of this reason.hm, 9:39 AM here in my place.
What time over there? Can't get to sleep?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
thans!!! Ale
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply