Permission issue
-
am I missing something?
-
You are pointing to (use the use statement) the correct database where this Invoice table exists, correct?
-
What is the result of running the GRANT statement on its own?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
yes, pointing to the correct database
result of grant is 'command completed successfully'
I can select from table as testuser
-
Instead of
Alter table [invoice.invoice]
try
Alter table invoice.invoice
Those square brackets around the schema.table might be the issue.The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
omg, it worked
- Phil Parkin - Thursday, July 12, 2018 8:57 AM
It's because [Invoice.Invoice] is a different object from [Invoice].[Invoice]. The first is just a table name, the second is a schema plus a table name. It's complaining, because you don't have a table named Invoice.Invoice in your default schema.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA -
thanks for the explanation, now i understand the cause
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply