So, you can effectively secure something like an XML document in both
a database and an application, or even both. Even for the scenario of combined features between
Access and SQL Server, there is still a distinct difference between database-level security and application
security, because a database stores data and an application consumes that data. Again, there is
1237
SQL Server as an Access Companion 40
crossover, such as with stored procedures in SQL Server, because stored procedures in a relational
database can operate functionally on data. An application operates functionally on data.
Access DDL Security Commands
Access 2007 allows execution of the following Data Definition Language (DDL) commands within
Access. These commands cannot be executed from within Access onto another database such as
SQL Server. Similar DDL commands can be executed in SQL Server directly, regardless of any communicating
Access 2007 database. These DDL commands are allowed in Access 2007:
n CREATE USER: Create one or more users with username and password:
CREATE USER
[, .
Pages:
2250
2251
2252
2253
2254
2255
2256
2257
2258
2259
2260
2261
2262
2263
2264
2265
2266
2267
2268
2269
2270
2271
2272
2273
2274