• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 43
  • Last Modified:

access for tables

Hi,
I have two three database stage dimensions and facts .

I want to query from fact database all dimension and stage database tables what grant command i need to run .

Thanks
0
sam2929
Asked:
sam2929
1 Solution
 
Vaibhav GoelMSBI , SQL ConsultantCommented:
Hello sam2929

Do you want to select data from these tables? If Yes then we need SELECT Permission on the table

GRANT SELECT ON yourTableName TO yourUserName;

Vaibhav
0
 
sam2929Author Commented:
it is localhost username window authentic so I don't think I need above command
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now