Home Database Mysql Tutorial Access入门教程19.5设置用户与组的权限和帐号[1]

Access入门教程19.5设置用户与组的权限和帐号[1]

Jun 07, 2016 pm 04:02 PM
access Getting Started Tutorial Permissions user set up

单纯的密码只能起到等不能打开这个数据库的作用 要使数据库的使用者拥有不同的权限 即有的人可以修改数据库你的内容 而有的人只能看看数据库的内容而不能修改 这就需要为不同的用户或某群用户组设置权限了 首先将鼠标移动到主菜单上的工具按钮上 然后单击鼠

    单纯的密码只能起到等不能打开这个数据库的作用要使数据库的使用者拥有不同的权限即有的人可以修改数据库你的内容而有的人只能看看数据库的内容而不能修改这就需要为不同的用户或某群用户组设置权限了

    首先将鼠标移动到主菜单上的工具按钮上然后单击鼠标左键会弹出一个子菜单将鼠标移动到这个菜单上的安全选项上会在这个选项右面弹出一个菜单将鼠标移动到这个菜单上的用户与组权限单击鼠标左键这样会在屏幕上弹出一个对话框


Access入门教程19.5设置用户与组的权限和帐号[1]

    在这个对话框中我们可以更改不同用户对数据库或其中的某个对象的访问权限假如我们想使用户李明只能打开运行数据库的窗体而不想要他能打开其他的表或查询只需要先在用户名中选择李明然后在对象类型下拉框中选择窗体现在选择一个窗体完后将鼠标移动到权限框中选中李明可有的打开/运行 完成这些后单击确定按钮就可以使李明在使用中只能看到窗体而不能修改其他的数据内容了也不能看到表或查询了

    上面我们只讲了怎样设置用户或组的权限但怎样才能将所需要的人都有一定的权限当然还必须要给每个用户或组一个帐号这样才能进行管理以便分配权限

    要实现这个功能就象刚才一样在安全选项右面的菜单中单击鼠标只是这次单击的是设置用户与组的帐号随后弹出的也是用户与组帐号对话框


Access入门教程19.5设置用户与组的权限和帐号[1]

    我们还要在这个对话框中管理用户或组在这个对话框中有三个选项卡第一个用来在在现有的组中管理用户的名称在这个选项卡上我们可以单击新建按钮在用户组其它组中添加新的用户也可以单击删除按钮将组中的这个用户删去单击清除密码就可以取消原来这个用户的密码

[]  []  

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to convert deepseek pdf How to convert deepseek pdf Feb 19, 2025 pm 05:24 PM

DeepSeek cannot convert files directly to PDF. Depending on the file type, you can use different methods: Common documents (Word, Excel, PowerPoint): Use Microsoft Office, LibreOffice and other software to export as PDF. Image: Save as PDF using image viewer or image processing software. Web pages: Use the browser's "Print into PDF" function or the dedicated web page to PDF tool. Uncommon formats: Find the right converter and convert it to PDF. It is crucial to choose the right tools and develop a plan based on the actual situation.

How to add and manage users in Google Manager How to add and manage users in Google Manager Sep 02, 2024 pm 02:41 PM

How to add and manage users in Google Manager? Google Chrome supports multiple users to log in, so we don’t have to worry about logging in across devices. If we have many users, we need to add management. Some friends may not know how to operate. Don't worry, the editor has compiled a detailed step-by-step tutorial for everyone today. If you are interested, come and take a look with the editor. Detailed step-by-step tutorial instructions 1. After turning on the computer, find the installed Google Chrome icon on the desktop and double-click to open it, as shown in the picture below. 2. Click the three dots icon in the upper right corner of Google Chrome, as shown in the picture below. 3. Click the [Settings] option in the drop-down menu of Google Chrome, as shown in the figure below. 4. In the Google Chrome settings interface that opens, click [Manage ch

How to solve the problem of third-party interface returning 403 in Node.js environment? How to solve the problem of third-party interface returning 403 in Node.js environment? Mar 31, 2025 pm 11:27 PM

Solve the problem of third-party interface returning 403 in Node.js environment. When we use Node.js to call third-party interfaces, we sometimes encounter an error of 403 from the interface returning 403...

Laravel Redis connection sharing: Why does the select method affect other connections? Laravel Redis connection sharing: Why does the select method affect other connections? Apr 01, 2025 am 07:45 AM

The impact of sharing of Redis connections in Laravel framework and select methods When using Laravel framework and Redis, developers may encounter a problem: through configuration...

What are the benefits of multithreading in c#? What are the benefits of multithreading in c#? Apr 03, 2025 pm 02:51 PM

The advantage of multithreading is that it can improve performance and resource utilization, especially for processing large amounts of data or performing time-consuming operations. It allows multiple tasks to be performed simultaneously, improving efficiency. However, too many threads can lead to performance degradation, so you need to carefully select the number of threads based on the number of CPU cores and task characteristics. In addition, multi-threaded programming involves challenges such as deadlock and race conditions, which need to be solved using synchronization mechanisms, and requires solid knowledge of concurrent programming, weighing the pros and cons and using them with caution.

How to avoid third-party interfaces returning 403 errors in Node environment? How to avoid third-party interfaces returning 403 errors in Node environment? Apr 01, 2025 pm 02:03 PM

How to avoid the third-party interface returning 403 error in the Node environment. When calling the third-party website interface using Node.js, you sometimes encounter the problem of returning 403 error. �...

How to use sql if statement How to use sql if statement Apr 09, 2025 pm 06:12 PM

SQL IF statements are used to conditionally execute SQL statements, with the syntax as: IF (condition) THEN {statement} ELSE {statement} END IF;. The condition can be any valid SQL expression, and if the condition is true, execute the THEN clause; if the condition is false, execute the ELSE clause. IF statements can be nested, allowing for more complex conditional checks.

Unable to log in to mysql as root Unable to log in to mysql as root Apr 08, 2025 pm 04:54 PM

The main reasons why you cannot log in to MySQL as root are permission problems, configuration file errors, password inconsistent, socket file problems, or firewall interception. The solution includes: check whether the bind-address parameter in the configuration file is configured correctly. Check whether the root user permissions have been modified or deleted and reset. Verify that the password is accurate, including case and special characters. Check socket file permission settings and paths. Check that the firewall blocks connections to the MySQL server.

See all articles