SQL Server 2005 Security

• Topics

  Started by

  Posts

  Last post

• DROP LOGIN

  Dear All, Could you please advise on the below error. Msg 15174, Level 16, State 1, Line 1 Login 'a…

  ravisamigo

  4 replies

  8 years, 5 months ago

  By: Miguel Angel Zavala Vizcaya-410089

• Q: How to Encrypt and Decrypt

  Hello all, I have a Database name 'ahmed' and more tables And have table name "Users" Users Table c…

  ahmadhassan

  6 replies

  8 years, 5 months ago

  By: ahmadhassan

• Linked Servers and Security Concerns

  The company I work at has a general policy not to link servers at all, and the DBAs won't really di…

  Jeff Weight

  17 replies

  8 years, 9 months ago

  By: jeremy.hughes 36229

• SA password lost

  Is there any way to recover 'sa' password. I know we can reset by ALTER LOGIN and but i just want t…

  manoj2001

  14 replies

  8 years, 10 months ago

  By: anita_lanctot

• How to hide objects (sp, views, tables) from a user?

  Hi, I have a user that I want to give SELECT permissios to only a couple of tables. The database co…

  rehman-615909

  6 replies

  9 years ago

  By: Lowell

• What does GRANT CONNECT exactly do?

  Hi I have just accidently happened to revoke the CONNECT right to some users on my test database. …

  Anders Hansen

  5 replies

  9 years, 1 month ago

  By: Jamie-2229

• Is there any way to script out Linked server with remote login password ?

  I have couple of linked servers on SQL server 2005 need to migrate to another SQL server 2005.I hav…

  SQLDBA346

  5 replies

  9 years, 3 months ago

  By: Luis Cazares

• Troubleshooting 18456 Severity 14 State 5

  In my error logs I am getting an 18456, Severity 14, State: 5. Which a first glance would be a fail…

  MattKent

  6 replies

  9 years, 4 months ago

  By: adey11

• Changing the GRANTOR for permissions

  We recently had a new SQL Server (Active\Passive) Cluster built at a new Hosting Facility for all …

  Jpotucek

  2 replies

  9 years, 4 months ago

  By: louislamour2673

• Server unable to access database under current context

   Hi guys. I created a database "MyDatabase" using an AD Account "user01" which is a member of …

  swarm

  5 replies

  9 years, 5 months ago

  By: mark.harby

• Restoration without sysadmin pemission

  Hi In my environment i need sql server restoration the database user without accessing data.with…

  vs.satheesh

  1 replies

  9 years, 7 months ago

  By: Lowell

• how to assign permission to start sql server active directory helper or Permission to start SQL Writer permissions

  Hi guys I have read the following document "Setting Up Windows Service Accounts" http://msdn.micros…

  shinobigoh

  2 replies

  9 years, 8 months ago

  By: emmanuel.rambaux

• Create table permission

  Hi, I am trying to give a user (ccr) to create table permission in 1 of db's. I ran this:- grant…

  SkyBVI

  4 replies

  9 years, 9 months ago

  By: jlp3630

• SQL server restoration with limited user rights

  Hi In my production server we are using sql server 2005 standard edition. My requirements i…

  vs.satheesh

  1 replies

  9 years, 9 months ago

  By: Lowell

• Deny Alter and Deny Drop permissions on ONLY Stored Procedures

  Good morning, We have a generic sql login "prduser". Applications use this login. We want the login…

  coolchaitu

  9 replies

  9 years, 9 months ago

  By: Ed Wagner