All Questions
Tagged with sql-server-2000 permissions
5 questions
8
votes
1
answer
24k
views
GRANT permissions to all tables, views, procedures in SQL Server 2000
I was wondering if there was a fairly efficient way to use T-SQL with SQL Server 2000 syntax to GRANT SELECT, INSERT, UPDATE, DELETE, on all TABLES and VIEWS for a particular database while excluding ...
- 1,143
1
vote
2
answers
720
views
What permission do I need for viewing... all current user permissions?
I'm maintaining an application that runs with SQL Server 8.0.760 SP3.
When I try to "see" the permissions of the current user I'm logged with, I do this:
SELECT * FROM fn_my_permissions(NULL, '...
- 1,513
2
votes
3
answers
701
views
What tasks can only sysadmin's do in SQL Server 2000?
I'm cleaning up permissions on my SQL Server 2000, and I want to verify that a particular account still has sysadmin privileges.
What non-destructive tasks can only sysadmins do that I can use to ...
- 394
15
votes
1
answer
3k
views
Are there reasons why I should not set my db owner to [sa]?
Yesterday I asked this question regarding changing the dbo of multiple databases that I have. The change makes sense, but I want to be clear.
Is there any, good reason or circumstance why I should ...
- 937
2
votes
1
answer
299
views
Active Directory domain being shutdown-- Do I have to update my DBO accounts?
I manage a SQL Server machine (with SQL Server 2000 and 2005 installed) that was first created on an Active Directory domain that we are transitioning away from and are about to shut down. All of my ...
- 937