Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 linked server

Author  Topic 

raul11
Starting Member

48 Posts

Posted - 2012-08-09 : 02:33:09
on an existing linked server, is there any way to find out what permissons does user abc have

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2012-08-09 : 19:44:09
The linked server creates a security context at the remote server; it still needs to login into the remote server. If you can determine the login being used, you should be able to go to the remote server and get the authorizations for that login.

=================================================
Show me a sane man and I will cure him for you. -Carl Jung, psychiatrist (1875-1961)
Go to Top of Page
   

- Advertisement -