This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ; (1) First take the access of the connect section. ; (2) If a user entry is found, it will override. ; [connect default] ;If we want to disable unknown connect values, we set Access to NoAccess Access=NoAccess A [sql default] ;If we want to disable unknown sql values, we set Sql to an invalid query. Sql=&quot; &quot; S [connect CustomerDatabase] Access=ReadWrite Connect=&quot;DSN=AdvWorks&quot; C [sql CustomerById] Sql=&quot;SELECT * FROM Customers WHERE CustomerID = ?&quot; S [connect AuthorDatabase] Access=ReadOnly Connect=&quot;DSN=MyLibraryInfo;UID=MyUserID;PWD=MyPassword&quot; C [userlist AuthorDatabase] Administrator=ReadWrite A [sql AuthorById] Sql=&quot;SELECT * FROM Authors WHERE au_id = ?&quot;...
View Full Document
This note was uploaded on 11/28/2011 for the course GEOL 101 taught by Professor Jeeze during the Spring '08 term at San Diego State.
- Spring '08