How To Build SELECT Statements Based on User Column Privileges (190064)
The information in this article applies to:
- Microsoft Visual FoxPro for Windows 3.0
- Microsoft Visual FoxPro for Windows 3.0b
- Microsoft Visual FoxPro for Windows 5.0
- Microsoft Visual FoxPro for Windows 5.0a
- Microsoft Visual FoxPro for Windows 6.0
This article was previously published under Q190064 SUMMARY
When writing SELECT statements that will be executed by users with varying
levels of column privileges on a SQL Server table, the SELECT statements
may not work for all users. For instance, if a user executes a "SELECT *
FROM..." statement and does not have privileges on all columns, the
statement will return an error and no data.
REFERENCES
Modification Type: | Minor | Last Reviewed: | 6/29/2004 |
---|
Keywords: | kbhowto KB190064 |
---|
|