Shulou(Shulou.com)06/01 Report--

Set up a read-only account and can only read certain tables.

Now let's share the steps of the operation with you.

The premise of this operation is that the database is relatively large, there are many data tables, and you need to select your own read-only data tables.

The operation of the new account should be no stranger, so I'll give you a screenshot and don't talk about it.

In the User Mapping tab on the left, set up the database you want to specify and select the new account and schema.

In this way, the new account is successful, find the data table of the database you need to read-only, right-click-Properties.

Set the account you want to add in the Permission tab on the left and give Select permission.

The purpose of this operation is to select the data table that you want to read-only among the many data tables, otherwise you need to delete the access rights of other data tables one by one.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.