SQL Server 2005 Security

• Topics

  Started by

  Posts

  Last post

• Problem with EXECUTE AS

  Hello all, I am working on setting up a proxy account to use for creating a database snapshot from …

  JSR_SDCA

  3 replies

  16 years ago

  By: JSR_SDCA

• SQL Server Cross Database Ownership Chaining failing

  I've deleted the text of this post, 'cause my boss thought the it contained some infor about our da…

  Chuck Bevitt

  3 replies

  16 years ago

  By: Chuck Bevitt

• Wrong Schema Owner

  Hello, I’m trying to delete a user in a SQL 2005 database and I receive the following error: TITLE:…

  shusta

  3 replies

  16 years ago

  By: JSR_SDCA

• sys.database owner_sid doesn't match sys.database_principals dbo sid

  We have a database, TeamTest, that lists my fellow dba, 'domain\useraaa', as the owner under the P…

  Marcia Q

  3 replies

  16 years ago

  By: Jeffrey Williams

• How is this user getting in???

  Okay... it has been a long day, but here is the scoop. New SQL Server 2005 Express install. Logins…

  mnDBA

  2 replies

  16 years ago

  By: Jeffrey Williams

• How to Prevent DBA's from viewing the data

  Hi All, Is there any way to prevent the DBA's (having SA role) from reading the data. The database …

  Subhash-63067

  25 replies

  16 years ago

  By: webrunner

• Permissions Audit for SSRS 2005

  I am trying to bring permission sprawl under control for Reporting Services. I wish to audit which…

  Steve J. Larson-327140

  1 replies

  16 years ago

  By: Jack Corbett

• Is there a way to remove the cancel button from a window?

  We have an audit trail, but if you hit cancel it allows you to pass without putting info. Or if you…

  Angela S.

  11 replies

  16 years ago

  By: Lowell

• Grant execute to "user"

  I'm needing to give execute permission to all the stored procedures in a db. I have found some ela…

  SQLdba-473999

  2 replies

  16 years ago

  By: SQLdba-473999

• Is it possible to use SQL Server Profiler and filter by user?

  Good day everyone, We would like to audit all sysadmin users in our server and track the changes / …

  cute_lhen05

  8 replies

  16 years ago

  By: cute_lhen05

• Best Way To Store Successful Logins in A Table

  After looking around this site and others, doeis this link demonstrate the best way to implement a …

  sgambale

  1 replies

  16 years ago

  By: PaulB-TheOneAndOnly

• List of the objects changed in the last X days

  Hi there, I need a help. I need to know how can I query or get the name of objects changed in last …

  Edvaldo Castro

  2 replies

  16 years ago

  By: Edvaldo Castro

• SQL Server 2005 server login worked, then did not

  I recently installed Sql Server 2005 Standard Edition on a newly installed Windows Server 2003 serv…

  crossmj

  8 replies

  16 years ago

  By: george sibbald

• Execute As works in SQL2005 but not when called by ASP page

  I created a user that is only allowed to execute stored procedures and not SELECT on a table. I ha…

  ringalsbe

  7 replies

  16 years ago

  By: Jack Corbett

• Question regarding locking out a user after failed login attempts

  Hopefully I'm just not looking in the right place for this ... Is there no way to configure your da…

  kramaswamy

  1 replies

  16 years ago

  By: Luke L