Creating a table (permission setting method) in SQL Server 2000 is prohibited _mssql

Recently help the Web site Management Server, found a SQL Server database was created D99_cmd, D99_tmp, D99_reg, site security has done a lot of, do not know where the problem, here to share the temporary solution

1, prohibit the creation of database tables

On the data to be blocked, such as the (jb51net) Right key property permission

2, the combination of MacFee prohibit the creation of users, modify ASP php files. Specific people can refer to the cloud Habitat community before the article.

3, test whether the normal creation of the table

Conn.execute ("CREATE table dxytmp (name varchar (255), id int)")

If prompted at the time of execution

Congratulations, the instructions are complete.

Cloud Habitat Community Original article, reproduced please indicate the source.