I need to know all the permissions available in MS SQL 2005 and also the privilleges that each role has been given. Is there any system table in SQL 2005 from where i can get both these information.
I have a query regarding the Default Public role to any New SQL Server Logins. Its exists by default can it be removed ?? Has Microsoft given any recommendations about this behaviour??