Is there a way to determine who created a stored procedure?
Thu, 3 Jul 2008 15:22:00 -0700
I'm using SQL Server 2005 and am wondering if there is a way to determine who
created a stored procedure? I've looked in sys.objects, but all it gives me
is the original create date and the last modified date. ...
|
Application Security based on SQL Security
Thu, 3 Jul 2008 02:10:01 -0700
Hi
i was wondering instead of implementing my own security schema inside my
application code is it recommended to depend on SQL Security so a user will
connect with user name and password and if he dont have a permission on SQL
to delete or update he will egt an message i feel its more simple what you
t ...
|
report of users
Wed, 2 Jul 2008 12:15:00 -0700
Suppose I should know this answer, but I'm drawing a blank.
For auditing purposes, I need to "Obtain a system generated listing of users
with production access for the systems" .
Basically, I'm looking for a stored procedure or something that will give me
the users. If something gives more details and far ...
|
Audit Fails for DOMAIN\Administrator account on SQL server 2005 instance
Tue, 1 Jul 2008 16:43:24 +0200
Hi!
I have a WSS 3.0 running on SQL Server 2005 Standard. It was upgraded from
SQL Server 2005 Express edition. Everytime I restart server I have 4 events
in the event log as follows:
1)
SQL Database 'SharePoint_Config ' on SQL Server instance 'WEBSRV1\SQLEXPRESS
' not found. Additional error informatio ...
|
The server principal "dhtest" is not able to access the database "dhtest2" under the current security context. (Microsoft SQL Server, Error: 916)
Mon, 30 Jun 2008 10:40:30 -0400
Hi,
I am running into an issue that I really need resolved today. Simply put, I
am getting the error:
The server principal "dhtest" is not able to access the database "dhtest2"
under the current security context. (Microsoft SQL Server, Error: 916)
But, the details are a little fuzzy...
I have two ins ...
|
"login failed for user ..." appears in event viewer repeatedly
Mon, 30 Jun 2008 07:32:02 -0700
Hello.
I have messages in event viewer several times per minute that say "Login
failed for user ....". The errors rotate through all the accounts that I have
setup in SQL.
I need direction in how to determine what is trying to login and how to
correct it. Are these attempts to compromise my system?
Th ...
|
Windows authentication still prompts for database login
Thu, 26 Jun 2008 13:43:44 -0600
SQL Server 2005:
I have some Crystal Reports XI reports that prompt the user with a full database login screen (server, database, username, password). The login shows Integrated Security as turned off and the database field is blank (that is where I think the problem lies).
* The report settings seem to the same ...
|
|
|
Securityadmin
Wed, 25 Jun 2008 12:30:01 -0700
I'm looking at the server role securityadmin in SQL Server 2005.
In Books Online it says like this.
"Members of the securityadmin fixed server role can grant both server-level
and database-level permissions."
I'm interested in what database-level permissions securityadmin can grant.
Can it grant access ...
|
Help We Got Hacked with a SQL Injector
Tue, 24 Jun 2008 13:54:00 -0700
Hello--
Over the weekend our IIS server that we host our website on started serving
up Trojans to everyone that visited our website. We traced it back to the
below (see link). http://s3cwatch.wordpress.com/2008/06/22/wwwj8j8heicnkjs/
We have a solid firewall and don't have any services enabled that we don ...
|
Server roles
Mon, 23 Jun 2008 09:44:10 GMT
I have an old master database, I can restore it with another name but
it can't replace the real master.
Is there any way I can se the info about server roles from this
database? I want to se which "role members" there is for different
server roles?
/Peter ...
|
