Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL and security....

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-07 : 09:56:33
Koorosh writes "Hi,
I have a hosting with sql support and only one account.
I have asp pages for normal visitors and admins. I want to have good security on admin sections and make sure visitors can not screw the data base with the connectivity they make.

Right now I have used only one user I have for all users so all login with the saem username and password. But all also have access to all tables as I have only one full access account.

The hosting company hesitates to give me more usernames so I could set the permissions on the new one for SELECT only pages for normal visitors.
What should I do?

Thanks,
Koorosh"
   

- Advertisement -