Sql2005
I have a table where 3 new fields where added that need secured. I have
group security defined for this database and one group conatins 30+ people
has datareader. I created a new group with just the people who can have view

I need to give backup/restore function to a user "dbo" for his own database.
This is on SQL 2005.
What permission do I need to setup for this user so I don't give too much.
Thank you for the great support.

Is it possible to disable the Windows Authentication mode in SQL Server 2005
and only SQL Server Authentication is available for login?
Regards,

I have converted my Access 2007 back end to a SQLServer and am trying to
return the current user back to the application.  Unfortunately if I use the
built in function CurrentUser is only returns Admin which is from Access and
if I try to use the TransactSQL function CURRENT_USER ...

I am a fairly new SQL2005 admin and have been struggling with setting up an
easy to manage, SQL2005 Security structure for our developers working with
BIDS and reporting/analysis services.
My general thought is to have a generic SQL user (SQLREPORT) that can be

What is the proper way to give any authenticated user access to a View
in SQL Server 2005?
I have a View that I would like to give any valid network
authenticated user access to so they can refresh a connected

Can SQL Server 2000 check the version of a software (made in VB 6) before
allowing it connect to database and decide whether it should be allowed to
login or not?
Regards,

hi im currently having a problem on my webserver. im getting an error
message as below:
This is filling my event viewer very quickly - im thinking this is an
attack of some description. what must i do to make sure that they cant

We sell a third party application that uses SQL 2005 as a back end.  It has
internal user accounts and creates a matching SQL Login when a user account
is created.  The default password is not complex and when password complexity
testing is enabled on the SQL Server, it causes ...

Oracle has a feature called "Virtual Private Databases" (VPD), that enables
you to configure permissions at row level. Is there an equivalent feature in
SQL Server?"

Is it possible to disable the Windows Authentication mode in SQL Server 2000
and only SQL Server Authentication is available for login?
Regards,
Muhammad Bilal

Is it possible to create a user which can connect to a SQL Server 2000
database and can select, insert and update tables in a database through
software (made in VB 6) but cannot login directly on Query Analyzer or
Enterprise Manager Console?

I am having an issues when i run reports on SQL Server 2008 Reporting
Services and when running Maintenance plans with in the database
engine.  My database engine,reporting and agent are all running as the
same domain account and it is for the same domain that the server and

Is there a way to grant "select" on all tables to one database role at one
time? Right now, I have to choose each of the tables, they are too many.
Thanks
Sg

Are SQL Server 2008 Logins (not integrated logins) passwords automatically
encrypted on the wire (I know they are on the hard drive) by default, or is
there a certain combinations of settings that must be used to have the
passwords encrypted on the wire.