最强的安全贴。可惜全是英文

yangzn

微软的贴子，我想应该是权威吧

yangzn

paul16

这是ＡＣＣＥＳＳ的帮助文件！中文版的就有了！

sea.er

以下是引用zhengjialon在2004-3-18 17:15:45的发言：
最强的ACCESS安全贴：
http://www.microsoft.com/china/msdn/library/dnacc2k2/html/odc_acsecurity.asp

yangzn

但是版主，你看中文版，少了很多的内容呀

比如文章中的这个（原文为htm的表格，在这里看不出来了）
.1 Table 1: DAO Security Constants
DAO Security Constants

All Container/Document objects:
Access 2.0
Access 95/97/2000

No permissions on object
DB_SEC_NOACCESS
dbSecNoAccess

Full permissions on object
DB_SEC_FULLACCESS
dbSecFullAccess

Can delete object
DB_SEC_DELETE
dbSecDelete

Can read an object's security-related information
DB_SEC_READSEC
dbSecReadSec

Can edit an object's permissions
DB_SEC_WRITESEC
dbSecWriteSec

Can change the Owner property of an object
DB_SEC_WRITEOWNER
dbSecWriteOwner

Table Container/Document objects:



Can create new tables / queries
DB_SEC_CREATE
dbSecCreate

Can read table definitions
DB_SEC_READDEF
dbSecReadDef

Can modify or delete table definitions
DB_SEC_WRITEDEF
dbSecWriteDef

Can read records
DB_SEC_RETRIEVEDATA
dbSecRetrieveData

Can add records
DB_SEC_INSERTDATA
dbSecInsertData

Can edit records
DB_SEC_REPLACEDATA
dbSecReplaceData

Can delete records
DB_SEC_DELETEDATA
dbSecDeleteData

Database Container/Document



Can create new databases (valid only on the Database Container object in the workgroup file, System.mda/mdw)
DB_SEC_DBCREATE
dbSecDBCreate

Can replicate database and/or change database password
N/A
dbSecDBAdmin

Can open the database
DB_SEC_DBOPEN
dbSecDBOpen

Can open the database exclusively
DB_SEC_DBEXCLUSIVE
dbSecDBExclusive

Access Security Constants

All Container/Document objects:
Access 2.0
Access 95/97/2000

Can execute form/report
DB_SEC_FRMRPT_EXECUTE
acSecFrmRptExecute

Can read the design of form/report
DB_SEC_FRMRPT_READDEF
acSecFrmRptReadDef

Can edit the definition of form/report
DB_SEC_FRMRPT_WRITEDEF
acSecFrmRptWriteDef

Can execute macro
DB_SEC_MAC_EXECUTE
acSecMacExecute

Can read macro definition
DB_SEC_MAC_READDEF
acSecMacReadDef

Can edit macro
DB_SEC_MAC_WRITEDEF
acSecMacWriteDef

Can read module definition
DB_SEC_MOD_READDEF
acSecModReadDef

Can edit module
DB_SEC_MOD_WRITEDEF
acSecModWriteDef*

yangzn

而且原文中有很多如何使用DAO的安全代码，这正是我找了很久的呀!（现在的都是用ADO的，可我的数据库一直是用的DAO）

[此贴子已经被作者于2004-3-20 9:54:33编辑过]

zhanguoru

請問:有沒有中文版!!!

yangzn

今天，总算把这个文章囫囵吞枣看完了。其中一点不知怎样做：就是我的工作组文件坏了，我想重建工作组文件，当然我在建工作组知道原来的用户名，组名和PID，这时应该怎么做呢？下面是它的英文件原文，但没讲具体的操作步骤。（If you have kept the user names, group names, and PIDs for your System.mda workgroup file, you can re-create this file from scratch.  If you do so exactly, you can then use this re-created workgroup file to regain full access to your MDB file. Even if you can't re-create all the users, if you can either re-create the owner of the database or the Admins group and create a member of Admins, then you can use that user to log on, de-secure your database (see Section 9) and then re-secure it.我想知道具体步骤。那么做个这个的，能不能讲一下。因为这太重要了，谁没个闪失。