Change the permissions on a local replica

HCL Domino Domino Forum
1

I have a local replica of a database. When I try to query a particular table from SQL Server Management Studio, I get the following error:

Msg 7314, Level 16, State 1, Line 2
The OLE DB provider “MSDASQL” for linked server “LINKED_SERVER_NAME” does not contain the table “TABLE_EXAMPLE”. The table either does not exist or the current user does not have permissions on that table.

I know the table exists. My question is, how can I change the permissions to my local replica to allow me to connect to and query this table?

2

Subject: Check view permissions too

Notes presents views as tables to SQL code so check the view and make sure it’s not restricted. This is in addition to the overall db’s ACL; your code could have access to the db but not to the view.

3

Subject: Permissions

check the Access Control List (ACL) of the local replica. Make sure that you ar a manager in the ACL.

4

Subject: Table Permissions

The item I am accessing is a an actual table, not a view.