Discussion :

[zoltix]

Comment faire pour relier les tables systems «SECURITY » avec «EXECUTION ENVIRONMENT » ?

Comment faire pour relier les tables systems «SECURITY » avec «EXECUTION ENVIRONMENT » ?
J’aimerais relier une des tables sys.dm_exec_connections, sys.dm_exec_sessions, sys.dm_exec_requests avec la tables sys.dm_exec_sessions Comment puis je faire pour relier ces tables ou une proposition pour associé les utilisateur connecté avec leur propres sécurité ?
Merci de votre aide

PS : c’est le schéma des tables Systems : http://www.microsoft.com/downloads/d...displaylang=en


select * from sys.dm_exec_connections where session_id=@@spid
select * from sys.dm_exec_sessions where session_id=@@spid
select * from sys.dm_exec_requests where session_id=@@spid
select * from sys.sql_logins

select * from sys.dm_exec_sessions

[zoltix]

Some info
IF PERMISSIONS()&2=2
CREATE TABLE test_table (col1 INT)
ELSE
PRINT 'ERROR: The current user cannot create a table.'
--------
This example determines whether the current user can
grant the INSERT permission on the authors table to another user.

IF PERMISSIONS(OBJECT_ID('authors'))&0x80000=0x80000
PRINT 'INSERT on authors is grantable.'
ELSE
PRINT 'You may not GRANT INSERT permissions on authors.'

------http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsql...>
How can I retrieve a list of objects and permissions for a specified role?
------------------------------------------------------------------------------
In SQL Server 2005, you can use the Has_Perms_By_Name() function
(http://msdn2.microsoft.com/en-us/library/ms189802.aspx).



This is an example of usage:

SELECT o.SchemaAndName,
has_perms_by_name(o.SchemaAndName, 'OBJECT', 'EXECUTE')
FROM (SELECT name, SCHEMA_NAME(schema_id) AS [schema],
SCHEMA_NAME(schema_id)+'.'+name AS SchemaAndName
FROM sys.objects
WHERE type = 'P') AS o


SELECT dperms.*
FROM sys.database_permissions dperms
JOIN sys.database_principals dprins
ON dperms.grantee_principal_id = dprins.principal_id
JOIN master.sys.server_principals sprins
ON dprins.sid = sprins.sid