Security (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Grant Execute on an SP

  Hi All,I've two databases on a server , DB1 and DB2. There is User1 who has Read\Write on DB1 and n…

  Arsh

  7 replies

  6 years, 4 months ago

  By: Arsh

• Security context of a trigger

  Hi All,Would be great if any body can advise what security context a trigger runs using , once its …

  Arsh

  1 replies

  6 years, 4 months ago

  By: Erland Sommarskog

• Limit Concurrent Logins by database and/or user ID

  In my environment I have a sql server 2008 database on 64bit architecture. The production database …

  kwoznica

  23 replies

  6 years, 7 months ago

  By: Gail Shaw

• Logon failure: the user has not been granted the requested logon type at this computer.error for SQL Services even though account has Log on as a Service priveledges

  I have a 2008 R2 instance running on a Windows 2008 Virtual Machine.  After a server reboot I …

  craig.d.brown

  6 replies

  6 years, 8 months ago

  By: craig.d.brown

• First time CoBIT audit experience....

  We had our first CoBIT audit. From the sql side I can only say the auditors want us …

  Barkingdog

  3 replies

  7 years, 1 month ago

  By: Sue_H

• SSRS And Inconsistent Kerberos Authentication

  Hi, I'm having problems with Double Hop Scenario With Kerberos Authentication. IE On Windows Client…

  Guðjón Kr. Sigurðsson

  1 replies

  7 years, 3 months ago

  By: wayne.yan

• Database Roles dbo_owner and db_datareader

  Hello all.. its been awhile and I have been way from SQL for a couple years.. Getting back into it …

  Steve Vassallo

  4 replies

  7 years, 5 months ago

  By: Erland Sommarskog

• ssis security

  Hi, we are saving passwords for all our packages in an xml file which is not very secure, is there …

  Tara-1044200

  1 replies

  7 years, 6 months ago

  By: Chris Harshman

• Permissions to access all sysusers records

  I have this problem I can not figure out.The users login to the database using their own SQL Server…

  JacekO

  12 replies

  7 years, 8 months ago

  By: Erland Sommarskog

• migrated to sql 2008 R2 from an old sql 2000 database using compatibility mode, some passwords don't work anymore

  so here's the situation.  We use an old proprietary piece of software made in vb.net from a lo…

  stephen.hare

  4 replies

  7 years, 9 months ago

  By: Erland Sommarskog

• Sql server old bug on update with the same colum

  Hello Don't think i'm crazy 🙂 but i remember there was a known bug on sql server update that as …

  andrea.dimaio

  2 replies

  7 years, 9 months ago

  By: andrea.dimaio

• In what format are the *.sqlaudit files?

  There is scant information about these files on the web. There's mention about a "Application Log F…

  Ray Sotkiewicz

  9 replies

  7 years, 10 months ago

  By: sunilsql4

• TRUSTWORTHY ON to let sproc execute across Dbs

  OK.... this problem again 🙂 Setup: Database: AllOurFinancialData We have an external group who i…

  Maxer

  4 replies

  7 years, 11 months ago

  By: Erland Sommarskog

• Schema name, Schema Owner and Login

  Hi guys, I have two logins abc_prod and abc_dev in my prod environment. All our objects are created…

  sqlenthu 89358

  5 replies

  7 years, 11 months ago

  By: sqlm0j0e

• what is the password complexity for sql 2008 r2

  Sorry, I'm aware this is a dumb question but can i find the answer for 2008? Grateful for replies.

  snomadj

  2 replies

  8 years ago

  By: snomadj