This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal


~Judy Dwoponevergon
Jul 10, 2015, 3:13 PM
5 Posts

Change the permissions on a local replica

  • Category: Accessibility
  • Platform: Windows
  • Release: 9.0.1
  • Role: End User
  • Tags: Replica,permissions
  • Replies: 3

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?

~Tip Ekresaman
Jul 11, 2015, 5:35 PM
212 Posts
Permissions

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

~Hank Lopvelutergon
Jul 13, 2015, 12:34 PM
100 Posts
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.

~Judy Dwoponevergon
Jul 20, 2015, 3:42 PM
5 Posts
Table Permissions

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


This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal