Post reply

Permission issue

  • July 12, 2018 at 8:02 am

    #373495

    am I missing something?

  • July 12, 2018 at 8:06 am

    #1997302

    You are pointing to (use the use statement) the correct database where this Invoice table exists, correct?

  • July 12, 2018 at 8:07 am

    #1997303

    What is the result of running the GRANT statement on its own?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • July 12, 2018 at 8:13 am

    #1997306

    yes, pointing to the correct database

    result of grant is 'command completed successfully'

    I can select from table as testuser

  • July 12, 2018 at 8:57 am

    #1997315

    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

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • July 12, 2018 at 9:12 am

    #1997320

    omg, it worked

  • July 12, 2018 at 9:28 am

    #1997333

    Phil Parkin - Thursday, July 12, 2018 8:57 AM

    Instead of 
    Alter table [invoice.invoice]
    try 
    Alter table invoice.invoice
    Those square brackets around the schema.table might be the issue.

    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

  • July 12, 2018 at 10:15 am

    #1997340

    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