The SQL Server/MSDE security system protects all tables, views, stored procedures, and other elements. SQL Server/MSDE has a two-tier security system that can grant or revoke very specific access rights.
As a user who grants permissions, you must have the permissions required to do so. A system administrator usually performs these tasks for larger SQL Server/MSDE installations, and regular users cannot edit the security settings.
You can fully use the options described next only if you have administrator privileges, such as, for example, the SQL Server/MSDE login name sa or membership in the system administrator server role.
In Access 2002 you can no longer administer users, access rights, ...