Browse by Tags

Let a user with minimal privileges see another user, simple with TSQL - SQL Server 2005

Published 11 March 8 7:5 PM | SSQA.net

You may be aware that by default, users that have minimal privileges cannot see other users in the sys.database_principals and sys.server_principals catalog views. This means that a user with minimal privileges that owns a table cannot see other users...

Filed under: sql server, BOL, permission, tsql, privilege, user schema, definition

How to resolve permission issues when you move a database between servers that are running SQL Server

Published 5 September 7 11:41 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications How to resolve permission issues when you move a database between servers that are...

Filed under: sql server, database, kba, permission, move, servers

TSQL to generate GRANT statements from a database

Published 17 August 7 5:45 AM | SSQA.net

select p . state_desc + ' ' + p . permission_name + ' OBJECT::' + s . name collate Latin1_general_CI_AS + o . name collate Latin1_general_CI_AS + ' TO ' + u . name collate Latin1_general_CI_AS + 'GO' , p .* from sys.database_permissions...

Filed under: sql server, performance, access, permission, system, tsql, grant

Error message when you install SQL Server 2005: "Cannot alter the login 'sa', because it does not exist or you do not have permission"

Published 12 June 7 12:36 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications Error message when you install SQL Server 2005: "Cannot alter the login 'sa', because it does not exist or you do...

Filed under: sql server, security, login, kba, permission, sa