An Access workgroup is much the same as a role in SQL Server. And an Access user is much the
same as a SQL Server user. Access allows authentication of users with passwords. SQL Server does
the same.
The only real difference is that the privileges allowed for allocation to users in Access are few.
Privileges in relational databases such as SQL Server and Oracle Database number in the hundreds
and are divided into system and object privileges. A system privilege allows access to metadata, such
as creating a new table. An object privilege allows access to data, such as adding new records to a
table.
Access (when using the .mdb format with workgroup security configured) pretty much parallels
Oracle and SQL Server security. Unlike Access, however, SQL Server and Oracle security is generally
applied to data, while Access workgroup security applies to data and the user interface. Data
security restricts or allows access to data. From the perspective of data in a SQL Server database,
you secure the content of applications, rather than the actual objects or front-end customer facing
parts of an application.
Pages:
2248
2249
2250
2251
2252
2253
2254
2255
2256
2257
2258
2259
2260
2261
2262
2263
2264
2265
2266
2267
2268
2269
2270
2271
2272