How to secure a table within a database?
Thu, 25 Sep 2008 11:00:21 -0700
I am trying to secure 2 tables within a db.
I have secured the db by creating 2 User Groups on the server and then
allowing the user groups as logins on the SQLServer/DB. In an attempt to
secure the tables in question I have tried two different ways to do so:
1) Using the properties of the tables in questio ...
|
Re: Stored Procedure / GrantDbAccess
Thu, 25 Sep 2008 11:50:24 -0400
On Thu, 25 Sep 2008 07:41:01 -0700, Doug
<Doug@discussions.microsoft.com> wrote:
>Thanks Roy. I thought that if I qualified the SP with the database name, it
>would look in that database for the SP and wouldn't find it.
When you are in a database other than master and execute a stored
procedure starting w ...
|
Facing Error: 15401 while creating local logins
Thu, 25 Sep 2008 01:44:01 -0700
Hi All,
I have SQL server installed on a cluster enviroment, current verison of the
SQL Server is (Microsoft SQL Server 2005 - 9.00.3152.00 (X64)).
Cluster enviroment is setup on Microsoft Windows Server 2003 R2 Ent. x64
Edition with SP2.
Issue i am facing is whenever i try to create a Local login in SQL ...
|
Security Question
Wed, 24 Sep 2008 19:12:35 GMT
Hi!
To better contextualize my question please take a moment to read the
following. As a dept we are transitioning out of Access and into SQL Server
2005. I am the "reporting guy", and our "data guy" has said that all my
reports need to be built off of stored procedures rather than queries that
access the ta ...
|
Which User account is used?
Wed, 24 Sep 2008 01:09:00 -0700
Hi. In SQL Server 2005 with Windows Authentication mode activated, I have a
user who is a member of an AD group which has been assigned as a database
User, but this user's login has also been associated with another User
account directly.
How does SQL Server decide which User account is used when this user ...
|
SA user has lost is SYSADMIN role
Tue, 23 Sep 2008 10:46:00 -0700
Hello,
I'm having a problem has none of my admin login (Windows or SQL base)
are able to perform system administration like maintenance plan, add a login,
etc. I'm running a SQL 2000 SP4 on a W2K3 enterprise server. This is my
production server and my data manipulators are complaining about not been
a ...
|
Stored Procedure / GrantDbAccess
Tue, 23 Sep 2008 06:49:00 -0700
We have 2 servers, one being the production server and the other an alternate
where we allow users to extract data for their own needs. During the night,
the database on the production server is backed up, and then restored to the
alternate server. A database on the alternate server contains users that
nee ...
|
|
|
how do I turn on the audit for users login and logout
Tue, 23 Sep 2008 06:45:02 -0700
Hi,
I want to turn on the audit log for users login/logout in which database in
sql 2005, how do I do this?
Thanks so much,
sg ...
|
Domain users group in sql 2005
Sun, 21 Sep 2008 12:06:34 -0700 (PDT)
On our production system we have this NT group called as [Domain Name
\Domain Users]. In our team none of us recall adding this group on our
production and moreover; this group is sysadmin on production system,
which scares me because, if, no one added this group on our runtime
system then how did it become sysa ...
|
sql injection question
Fri, 19 Sep 2008 07:55:00 -0700
Using SS2005 and Windows2003 and a Linux web server in another location.
Would having the web server and database server in the same location, behind
the same firewall, make sql injection any less likely. Or is the prevention
of sql injection more about programming (i.e. using stored procedures vs raw
sql in ...
|
