Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On


SQL Server 2005 Security Expand / Collapse
TitleStarted ByRepliesViewsLast Post
Topic (New Replies)
dbCreator can restore a database but not then access it  
The dbCreator role can restore a database and will become the database owner but it cannot access the database

Jimmy M 5 3,315 Wednesday, July 15, 2015 2:25 PM
Last Post By: blurrytextfile
Hot Topic (New Replies)
Default NTFS permissions on new DB  
Ross Biddle 22 3,798 Wednesday, July 15, 2015 6:37 AM
Last Post By: bernard.baeten
Topic (New Replies)
Having trouble granting user login select permission on msdb.sysmail_allitems  
I would like to allow my application to view the status of system generated emails but I cannot retrieve data from msdb.sysmail_allitems. I suspect I do not have the permissions correctly configured.

William Plourde 2 1,345 Tuesday, July 14, 2015 7:18 AM
Last Post By: jacktipsword
Hot Topic (New Replies)
Sleeping process...  
bytezone 16 18,631 Monday, June 1, 2015 8:57 AM
Last Post By: reddysiri517
Hot Topic (New Replies)
GRANT EXECUTE ... TO [blah] AS [dbo] - What does the "AS DBO" do exactly?  
Maxer 14 8,081 Friday, May 22, 2015 6:02 AM
Last Post By: Coozie
Topic (New Replies)
How to test for presence of master key, certificate and symmetric key?  

paul-v 3 5,697 Thursday, May 14, 2015 12:47 PM
Last Post By: Lowell
Topic (New Replies)
Identify/Map Application users in sql 2005 database  

metroman17 2 130 Wednesday, April 29, 2015 12:37 PM
Last Post By: Ed Wagner
Topic (New Replies)
Identify/May Application users in sql 2005 database  

metroman17 3 121 Wednesday, April 29, 2015 12:30 PM
Last Post By: Lowell
Topic (New Replies)
Lisr DB users and permissions (also through roles)  

metroman17 1 94 Tuesday, April 28, 2015 2:11 PM
Last Post By: Steve Jones - SSC Editor
Topic (New Replies)
How do you block users from accessing tables directly?  

Rod at work 3 312 Monday, April 27, 2015 3:52 PM
Last Post By: Matt Miller (#4)
Topic (New Replies)
The server principal 'MyDomain\DomainUserA' already exists.  
The server principal 'MyDomain\DomainUserA' already exists.

ndohmen 4 9,759 Tuesday, April 14, 2015 7:33 PM
Last Post By: Tergum Rufus
Topic (New Replies)
Decryption Issue  

lhowe 0 201 Tuesday, March 24, 2015 11:49 AM
Last Post By: lhowe
Topic (New Replies)
Can't get decryption to work please help  

Jeffery Williams 0 146 Monday, March 16, 2015 9:46 AM
Last Post By: Jeffery Williams
Topic (New Replies)
How can i hide all DBs for a single user but still have them in the SQLAgent MSDB roles?  

Steven Jones-245254 2 177 Thursday, March 12, 2015 3:09 AM
Last Post By: Steven Jones-245254
Topic (New Replies)
Restoring database with TDE to a 2nd instance  

winston Smith 4 3,958 Monday, March 9, 2015 4:01 AM
Last Post By: pramod.singh 40121


Permissions Expand / Collapse

Topic Key Expand / Collapse
Topic (New Replies)  Topic (New Replies)
Topic (No New Replies)  Topic (No New Replies)
Hot Topic (New Replies)  Hot Topic (New Replies)
Hot Topic (No New Replies)  Hot Topic (No New Replies)
Poll (New Replies)  Poll (New Replies)
Poll (No New Replies)  Poll (No New Replies)
Closed Topic  Closed Topic
Moved Topic  Moved Topic