Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Hi all- I have couple of questio
- Thread starter man72
- Start date
PatrickP61
Programmer
Man72
Try this:
1. Write a query that retrieves all the table names.
2. Export that data list into a file.
3. Create a query that grants the authority you want
based on a variable tablename.
4. Edit the data list from #2 in such a way to call #3 query.
5. Import the data list into a proc.
6. Save the proc and execute it.
Try this:
1. Write a query that retrieves all the table names.
2. Export that data list into a file.
3. Create a query that grants the authority you want
based on a variable tablename.
4. Edit the data list from #2 in such a way to call #3 query.
5. Import the data list into a proc.
6. Save the proc and execute it.
- Status
