-
t-sql grant select help please
Ok, this forum is new to me so here goes,
I inherited an access 2 db of 200MB+ and have moved it onto SQL7, the database has 250+ tables with the front end accessing via a single .dbo account. I am by company default required to use Crystal Reports to display the information and have have created a 'read only' account (non dbo) for this purpose as db_datareader but it does not appear to have select rights against any tables.
I am looking for a 'simple' way of allowing select against all the tables.
eg: Grant Select on q4w_data.dbo.cm_hi_wk to [Q4W_Report]
How about Grant Select on q4w_data.dbo.sysobjects to [Q4W_Report]?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|