|
|
Browse by Tags
All Tags » security » login (RSS)
Showing page 1 of 2 (11 total posts)
-
While I was scrolling through the logins for a permission task, I found the login name such as ##MS_PolicyEventProcessingLogin## & ##MS_PolicySigningCertificate##, I was bit confused and perplexed to see what it is for?
As usual searching in Books Online (2008) and on web doesn't get much information on this login properties, also this ...
-
How to find all the owners of entities contained in a specified schema?
USE <database_name>;
GO
SELECT 'OBJECT' AS entity_type
,USER_NAME(OBJECTPROPERTY(object_id, 'OwnerId')) AS owner_name
,name
FROM sys.objects WHERE SCHEMA_NAME(schema_id) = '<schema_name>'
UNION
SELECT 'TYPE' AS entity_type
...
-
SP_HELP_REVLOGIN stored procedure helps you to generate a script that can be used to recreate the logins that exist on a server at a specific point in time script the logins along with password. I'm not sure how many DBA are aware of this Stored Procedure and it is described in KB article 246133. Though it talks about SQL ...
-
One of my colleague has been getting following error when trying to open few logins properties to change their default databases using SSMS.
TITLE: Microsoft SQL Server Management Studio------------------------------Cannot show requested dialog.------------------------------ADDITIONAL INFORMATION:Cannot show requested dialog. ...
-
Last week I have been delegated to finalize the security standards within a set of SQL 2005 instances that are used by a customer, though it is usual chores for me to apply industry best practices.
On these SQL 2005 instances in particular I was more keen on applying ''disabling SA account''!
I was confronted by a Database developer that ...
-
I haven't seen any probability of revealing password by using any method in SQL server, if you have SYSADMIN privilege login then you could try resetting password for that troubled login.
If not you can try running SP_HELP_REVLOGIN sp that will string out the password in HASH format.
-
As you may be aware using SQL 2005 version you can set PASSWORD EXPIRY policy that can apply the same complexity and expiration policies used in Windows Server 2003 operating system to passwords used inside SQL Server. This functionality depends on the NetValidatePasswordPolicy API, which is only available in Windows Server 2003 and later ...
-
The following query will get you the information to find out the groups that contain user login token on that server principal:
SELECT name, usage, type FROM sys.login_token
ORDER BY usage, type, name
go
To find any Windows principal in the token that has an entry in SQL Server server_principals view ...
-
Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard EditionNotification Contents: New and All Modifications
Error message when you install SQL Server 2005: ''Cannot alter the login 'sa', because it does not exist or you do not have permission''http://support.microsoft.com/kb/917827/en-US
-
SELECT name, principal_id, type_desc, is_disabled, default_database_name, default_language_name
FROM sys.server_principals
WHERE name = 'login_name'
go
SELECT name, database_id, user_access_desc, state_desc, is_in_standby
FROM sys.databases
WHERE ...
1
|
|
|