Re: How to find out if a login has permission for an obj?

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 08/08/04 

Date: Sun, 8 Aug 2004 08:46:07 +0100

Hi

It will be the database user that has the permissions on the object and a
given login will map onto that user. Check out the PERMISSIONS ( [ objectid
[ , 'column' ] ] ) function in books online.

John

"ryu" <blizzardstorm8899@yahoo.com> wrote in message
news:edLo$TRfEHA.3732@TK2MSFTNGP11.phx.gbl...
> Is there a way for me to find if there is a way to find out whether a
login
> has permissions for a db obj using only TSQL?
>
>

Relevant Pages

  • Re: Clients not able to login to Domain
    ... on subsequent attempts with other workstations ... it may be a "permissions" issue. ... > You say Not able to login, but then your error is not able to map? ...
    (microsoft.public.windows.server.sbs)
  • Re: Clients not able to login to Domain
    ... Passwords are supposed to remained synched between AD and Novell, ... it may be a "permissions" issue. ... >> You say Not able to login, but then your error is not able to map? ...
    (microsoft.public.windows.server.sbs)
  • Re: Clients not able to login to Domain
    ... You say Not able to login, but then your error is not able to map? ... If more than one I'd say it's Permissions on the directory where you are ... > The network path was not found." ...
    (microsoft.public.windows.server.sbs)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)