SQL Server 2005 Security

• Topics

  Started by

  Posts

  Last post

• Trigger to add user to db_owner role after db restore

  Hi, I have requirement where I need to restore production dbs on dev servers. I have an login ac…

  siddhartha20

  7 replies

  10 years, 10 months ago

  By: Michael-401546

• SQL Credentials to Access Network File

  I've noticed a lot of good info here, so I'm hoping this community can help. For days now, I've bee…

  steventnorris

  8 replies

  10 years, 11 months ago

  By: steventnorris

• SQLServer2005MSSQLUser$ComputerName$MSSQLSERVER

  Hi, In the MSSQL folder (windows explorer), under the security tab I see this group or username: S…

  Nsh

  12 replies

  11 years ago

  By: siddiquiIF

• Determine the user who entered data

  I have been tasked to enable auditing on data entry in a SQL Server 2005 database. Specifically, I…

  Patrick Gillespie

  2 replies

  11 years ago

  By: Patrick Gillespie

• Using Logon Trigger to exclude SSMS connections

  Hi all, Somehow, the application ID/PW became known to certain individuals within my organization. …

  lbrady

  1 replies

  11 years, 1 month ago

  By: lbrady

• How to deny restore database in sql server to SA?

  Hi need a help ? Mistakenly restored the prod database instance instead of development and i am hav…

  das.saroj09

  35 replies

  11 years, 2 months ago

  By: Brandie Tarvin

• Cannot connect to SSIS from SSMS

  I am using SP2 and cant connect to SSIS from SSMS. Also, I have another problem. I try to connect t…

  toparsi

  6 replies

  11 years, 2 months ago

  By: jayant.m.1

• User logins versus service account

  We have an application that uses Windows authentication to the database. Logins are created for ev…

  Leah

  2 replies

  11 years, 3 months ago

  By: Brad Joseph

• sqlserver 2005 database security different between database role and application role

  sqlserver 2005 database security different between database role and application role

  ganeshanmsc

  2 replies

  11 years, 3 months ago

  By: vincehorst

• Restrinct for insert update and delete from a specific table

  hello experts, In my existing database one table we are going to create like Sql_Audit_table. I wan…

  Zeal-DBA

  12 replies

  11 years, 4 months ago

  By: Sean Lange

• Can it be possible SQL Login creation with an empty password

  Hi I would like to know that, Is that possible to create SQL Login with blank password in SQL Serve…

  mohan.bndr

  4 replies

  11 years, 4 months ago

  By: Eric M Russell

• Deny delete and drop permission to the sql user

  Hi, how to deny delete and drop permission to the sql user for a particular database in sql server …

  anjan.ashok

  13 replies

  11 years, 4 months ago

  By: joseph-397214

• How to Grant User access to View Linked Server Properties

  hi, i need to give a User access to just VIEW the properties of a Linked Server. I've tried giving …

  kaotic504

  1 replies

  11 years, 4 months ago

  By: TJT

• View and User-Rights (Application Role)

  Hi all, I'm not sure how to explain my problem properly, so I'll start from the scratch: I have a d…

  stryk

  10 replies

  11 years, 4 months ago

  By: chrisgatguis

• How do I remove a table where TABLE_SCHEMA IS NULL

  I have an application that creates and removes tables as part of its process. For some reason it d…

  relentless99

  6 replies

  11 years, 6 months ago

  By: dao.tran