Access permissions on tables for current user

From: Gayatri Sathe (gayatri@persistent.co.in)
Date: 10/04/02 

From: "Gayatri Sathe" <gayatri@persistent.co.in>
Date: Fri, 4 Oct 2002 19:26:06 +0530

Hi,

I want to find out the access permissions available to the user associated
with the current login for each database in sqlserver. Is this information
available
in some table/s or views?

There is a view TABLE_PRIVILEGES which contains one row for each table
privilege
granted to or by the current user in the current database. But all the
tables on which I have
explicitly granted select permissions to the current user are not present in
the
TABLE_PRIVILEGES view.

Regards,
Gayatri

Relevant Pages

  • Data Objects for Win and Web
    ... We have a set of objects that use a DAL to connect to SQLServer. ... database they will be using is selected during login. ... Phenix ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Linked Server Connection Error: 18459
    ... I cannot execute the sqlcmd query against the linked server from sqlServer A to sqlServer B but I can run the linked server query from B to A. ... Login failed for user xxxxx\yyyyy. ... I do notice that the login is trying to connect to the master database via the linked server connection however this login is actually defauted to another user database. ...
    (microsoft.public.sqlserver.connect)
  • error conection frm clients to the sqlserver
    ... computer with ' MIS' name.the type of SQLserver installation is mixed mode ... network clients without login to the SQlserver besuse the sqlserver is mixed ... sqlserver database without login to SQLserver computer. ...
    (microsoft.public.sqlserver.connect)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ...
    (comp.lang.php)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... the postgres user they are logged in as to one that can make ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ...
    (comp.lang.php)