My goal is to link the security's tables with the session's tables,

Hi,
I would like to do a link between system table. My goal is to link the
security's tables with the session's tables, To see the security for
the current user. For example I would to do a request select * from
sys. sys.dm_exec_connections inner join....sys.database_permissions to
see if this user has the privilège for doing a "select"
Therefore how can I do a link between sys.dm_exec_connections (Current
session @@spid) and sys.database_permissions(define all permissions on
db) or perhaps other to see what I want.
Thank a lot for your response...
.

Relevant Pages

  • Re: Login in dynamically
    ... different from or nothing to do with the provisions of Access ULS. ... I mean, there's enough damn security permissions to set, how many do you want ... security as per transaction and not per application session. ...
    (microsoft.public.access.security)
  • Re: [Keyrings] [PATCH] Keys: Add LSM hooks for key management
    ... Should I expand the permissions mask to include a setattr? ... > security ops, although LSPP may require some form of get_security. ... for a key created by request_key, and is limited to the keyrings the process ... This does need a security hook, at least for joining an existing session. ...
    (Linux-Kernel)
  • I would like to do a link between system table.
    ... security's tables with the session's tables, ... session @@spid) and sys.database_permissions(define all permissions on ...
    (microsoft.public.sqlserver)
  • RE: What server hardening are you doing these days?
    ... permissions on their data, and Microsoft encourages ISVs to minimize ... I've been able to discuss ACLs and other security issues in Windows with ... Control or DAC (which is what you're referring to by the "stupid ...
    (Focus-Microsoft)
  • Re: Desktop Creation
    ... Your statement only gives one small piece of the security picture. ... The reason for no desktop window access by services is that an unsecured ... session 1 and communicate with an IPC with the SYSTEM service. ... API evolution. ...
    (microsoft.public.win32.programmer.kernel)