Table creation is prohibited in SQL server 2000 (permission setting method ).

Table creation is prohibited in SQL server 2000 (permission setting method ).

When I recently helped my website to manage the server, I found that D99_CMD, D99_Tmp, and D99_REG were created in an sqlserver database. I have done a lot in website security and do not know what went wrong, here we will first share the temporary solution

1. Do not create database tables

On the data to be denied, for example, right-click (jb51net) and choose attribute> permission

2. You are prohibited from creating users and modifying asp PHP files by using macloud. For details, refer to the previous articles on helping customers.

3. test whether a table can be created normally.

Conn.exe cute ("create table dxytmp (name varchar (255), id int )")

If the prompt is displayed during execution

Congratulations! The settings are complete.

The original Article of the customer's house. For more information, see the source.