User Access to databases

  • The minimum permissions the user will need will be:

    Select on the view itself.
    Select permissions on any tables referenced by the view, that are not in the local database.

    Users will have to be created in any database that permissions are granted in.

    To make your future life easier, you will likely want to collect these permissions and assign them to a role, so if you need to do this for a second user, it will go much easier.  Of course, you have to remember how many databases to assign those permissions in.

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply