保护数据库 [英] Securing a Database

问题描述

问候。我正在寻找一些关于使数据库安全的建议。

安全，我的意思是我只想让某些人拥有写入权限

到数据库，我想要允许更新，而其他

只读用户可能正在浏览和生成报告。


我正在使用MS / ACCESS 2000并希望拆分数据库

进入前端和后端，然后将后端放到我所有组都可以访问的共享

驱动器上。我的目标是我的所有

团队成员（同事）在他们的桌面上都会有一个快捷方式图标和

他们中的一些人将拥有比其他人更多的权限 。有些人将获得

只读访问权限，而其他人将拥有读取/更新/删除访问权限。


我一直在阅读一些尝试自我教育的信息但是真的很好

在我搞砸之前需要一些指导。


1.我应该首先分割数据库吗？

2 。接下来我设置了ADMIN密码？

3.我应该使用安全向导吗？如果是这样，任何指针？我已经创建了一些测试数据库，试图进行测试运行并且失败了

惨不忍睹。


先谢谢所有你的帮助。

Sue


***通过Developersdex发送 http://www.developersdex.com ***

不要只是参加USENET ......获得奖励！

Greetings. I am looking for some advice on making a database secure.
By secure, I mean that I want only certain people to have write access
to the database and I want the updates to be permitted while other
read-only users may be browsing and generating reports.

I am working with MS/ACCESS 2000 and would like to split the database
into a front-end and back-end and then put the back-end onto a shared
drive that all of my group has access to. My goal is that all of my
team members (colleagues) will have a shortcut icon on their desktop and
some of them will have more ''permissions'' than others. Some will have
read-only access and others will have read/update/delete access.

I have been reading some information trying to self-educate but really
would like some guidance before I really screw this up.

1. Should I split the database first?
2. Shoud I set the ADMIN password next?
3. Should I use the Security Wizard? If so, any pointers? I have
created some test databases trying to do test runs and have failed
miserably.

Thanks, in advance, for all your help.
Sue

*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!

推荐答案

研究本白皮书/常见问题解答......
http://support.microsoft.com/default...ent/secfaq.asp


- Jim


2004年5月24日19:06:32 GMT，Susan Bricker< sb **** @ att.net>写道：

Study this white paper/FAQ...
http://support.microsoft.com/default...ent/secfaq.asp

- Jim

On 24 May 2004 19:06:32 GMT, Susan Bricker <sb****@att.net> wrote:

问候。我正在寻找一些关于使数据库安全的建议。
通过安全，我的意思是我只希望某些人对数据库具有写入权限，并且我希望允许更新，而其他
我正在使用MS / ACCESS 2000并希望将数据库分成前端和后端然后将后端放到我所有组都可以访问的共享
驱动器上。我的目标是我的所有团队成员（同事）在他们的桌面上都有一个快捷方式图标，其中一些人比其他人拥有更多的权限。有些人会有只读访问权限，有些人会有阅读/更新/删除访问权限。

我一直在阅读一些尝试自我教育的信息但是真的想要一些在我真正搞砸之前的指导。

1。我应该首先拆分数据库吗？
2。 Shoud我接下来设置ADMIN密码？
3。我应该使用安全向导吗？如果是这样，任何指针？我已经创建了一些测试数据库，试图进行测试运行并且失败了。

提前感谢您的帮助。
Sue
***通过开发人员指南 http://www.developersdex.com 发送***不要只是参加USENET ......获得奖励！

Greetings. I am looking for some advice on making a database secure.
By secure, I mean that I want only certain people to have write access
to the database and I want the updates to be permitted while other
read-only users may be browsing and generating reports.

I am working with MS/ACCESS 2000 and would like to split the database
into a front-end and back-end and then put the back-end onto a shared
drive that all of my group has access to. My goal is that all of my
team members (colleagues) will have a shortcut icon on their desktop and
some of them will have more ''permissions'' than others. Some will have
read-only access and others will have read/update/delete access.

I have been reading some information trying to self-educate but really
would like some guidance before I really screw this up.

1. Should I split the database first?
2. Shoud I set the ADMIN password next?
3. Should I use the Security Wizard? If so, any pointers? I have
created some test databases trying to do test runs and have failed
miserably.

Thanks, in advance, for all your help.
Sue

*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!

感谢您提供的信息。我一直在学习......并且参加测试

运行我的数据库的测试版本。我还有一些问题，

虽然。


我的应用程序有表单，有单独的命令按钮可以浏览

（查看） ，编辑，添加，保存记录。当具有只读访问权限的用户登录到

应用程序时，我想禁用

适当的按钮。我一直在搜索在线帮助和常见问题列表，并且

还没有成功地通过编程方式确定如何确定...... b / b确定......
/>
1.谁登录？ （用户名）

2.用户在哪个组？ （组名）这将暗示分配给用户的

权限。


我应该如何处理这项任务？我想在初始的Switchboard打开事件函数中调用

a调用一个新函数。

新函数会找出用户是谁以及组名和

然后设置一个全局变量（我已经定义了一个全局的

变量集合，并且可以为集合添加另一个变量）。然后

每当新表格打开时我都可以检查全局变量和

随意禁用/启用各种按钮。


您怎么看？


谢谢。

Sue



***通过Developersdex发送 http://www.developersdex.com ***

不要只是参加USENET ......获得奖励！

Thank you for the information. I have been studying ... and taking test
runs with test versions of my database. I still have some questions,
though.

My application has forms that have separate command buttons to browse
(view), edit, add, save a record. I would like to disable the
appropriate buttons when a user with read-only access logon into the
application. I have been searching the online help and the FAQ list and
have not been successful in figuring out, programmatically, how to
determine ...

1. Who is logged on? (user name)
2. What group is the user in? (group name) which will imply the
permissions assigned to the user.

How should I go about this task? I was thinking something like putting
a call to a new function in the initial Switchboard open event function.
The new function would find out who the user is and the group name and
then set a global variable (I, already, have a global Collection of
variables defined and could another variable to the collection). Then
whenever a new form opens I could inspect the global variable and
disable/enable the various buttons at will.

What do you think?

Thanks.
Sue


*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!

感谢您提供的信息。我一直在学习......并且参加测试

运行我的数据库的测试版本。我还有一些问题，

虽然。


我的应用程序有表单，有单独的命令按钮可以浏览

（查看） ，编辑，添加，保存记录。当具有只读访问权限的用户登录到

应用程序时，我想禁用

适当的按钮。我一直在搜索在线帮助和常见问题列表，并且

还没有成功地通过编程方式确定如何确定...... b / b确定......
/>
1.谁登录？ （用户名）

2.用户在哪个组？ （组名）这将暗示分配给用户的

权限。


我应该如何处理这项任务？我想在初始的Switchboard打开事件函数中调用

a调用一个新函数。

新函数会找出用户是谁以及组名和

然后设置一个全局变量（我已经定义了一个全局的

变量集合，并且可以为集合添加另一个变量）。然后

每当新表格打开时我都可以检查全局变量和

随意禁用/启用各种按钮。


您怎么看？


谢谢。

Sue



***通过Developersdex发送 http://www.developersdex.com ***

不要只是参加USENET ......获得奖励！

Thank you for the information. I have been studying ... and taking test
runs with test versions of my database. I still have some questions,
though.

My application has forms that have separate command buttons to browse
(view), edit, add, save a record. I would like to disable the
appropriate buttons when a user with read-only access logon into the
application. I have been searching the online help and the FAQ list and
have not been successful in figuring out, programmatically, how to
determine ...

1. Who is logged on? (user name)
2. What group is the user in? (group name) which will imply the
permissions assigned to the user.

How should I go about this task? I was thinking something like putting
a call to a new function in the initial Switchboard open event function.
The new function would find out who the user is and the group name and
then set a global variable (I, already, have a global Collection of
variables defined and could another variable to the collection). Then
whenever a new form opens I could inspect the global variable and
disable/enable the various buttons at will.

What do you think?

Thanks.
Sue


*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!

这篇关于保护数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！