Stored Procedure Security
Wed, 17 Mar 2010 18:10:01 -0700
I was under the impression that granting execute security on a stored
procedure would allow a user to run the procedure. My experience, however,
is that security must also be granted to all the tables, functions, etc...
that are used by the stored procedure. Why isn't granting execute authority
enough? ...
|
using certificate on tables
Wed, 17 Mar 2010 18:25:17 +0200
Hello there
I have database which i had to grant select on some tables for specific
users. In order to use these tables on dinamic sql.
I just found out that i can use certificate on sql 2005-2008 to allow select
on these tables from specific procedures without grant the select on that
table.
It sound ...
|
Configure SQL 2005 for Kerberos Authentication
Wed, 17 Mar 2010 00:46:01 -0700
Hi,
I'm currently trying to setup SCCM 2007 with the SCCM database on a remote
SQL 2005 SP3 server (not in the default instance)
I've configured the SPN as per this guide:
http://support.microsoft.com/kb/909801
and followed the steps in this guide for the SCCM side:
http://technet.microsoft.com/en-us/ ...
|
Backing up permissions for SQL Server 2000
Fri, 12 Mar 2010 09:56:08 -0800 (PST)
Is there a method to back up all permissions in SQL Server 2000? I am
looking for a way to get all the permissions for all of the databases,
then be able to run a query to re-populate the permissions. This is a
work around for a migration to a new domain. The tool that is used to
populate new users into SQL S ...
|
Moving Encrypted data from server to server
Tue, 9 Mar 2010 13:19:02 -0800
I have successfully restored a db from Server A to server B and then
1. OPen Master
2. Open Symmetric Key
3. Read Data ... GOOD!
The above, proved to me that I have encryption working.
I then tried and failed to move JUST a table with encrypted data into a new
database... Can someone tell me if i am ...
|
Mixed auth, but Login failed for user 'testlogin'. Not assoc with trusted sql server connection.
Mon, 8 Mar 2010 15:20:46 -0800
I have a sql server 2005 express installation which allows mixed
authentication. I created a sql server login 'testlogin' and used that
as the login for a new user 'testuser' on 'testdb'. testuser has
dataread and datawrite role on testdb.
I'm attempting to create an odbc connection to testdb with the testl ...
|
What permissions/role is required to read SQL Logs
Mon, 8 Mar 2010 09:14:01 -0800
Hello,
In our SQL Server environment, both SQL Server and the SQL agent are
configured to run under their own domain accounts. This being the case, what
permissions or roles are required to see the SQL Logs in SSMS (SQL 2K5)?
TIA,
Rich ...
|
|
|
why did sa prevent me from unlocking it?
Thu, 4 Mar 2010 14:31:02 -0800
Hello:
sa was locked out after multiple password attempts. So, I went into SQL
Management Studio in SQL 2005 using Windows Authentication.
Then, I went into the Properties of the "sa" login. I found the checkbox
for unlocking the login. After unchecking it and clicking "Save" or "OK" or
whatever, an e ...
|
Pb to connect to a SQLServer database via Terminal Services
Thu, 4 Mar 2010 07:51:01 -0800
Hi,
We have two servers on our domain : one for datas with SQLServer Express
2005 and another for applications server with Terminal Services, on the
latter we have installed our application.
When we connect with the domain administrator session in our application, we
manage to connect to the sqlserver da ...
|
How can I grant select only to a specific connection
Tue, 2 Mar 2010 03:49:01 -0800
Hi all, I need to createthe following scenario.
In my DB a user should call only a stored procedure that GRANT dinamically
SELECT for a specific table on a specific schema.
In addition this GRANT must be revoked when the connection who calls the
stored procedure is closed.
I've succesfully write a stored pr ...
|
