Exasperant
Guppy
Hi everyone.
OK, I write because I need some explanations or more precision about MS SQL and login user.
I created two login account. One admin, other one simple user.
I created one database.
When I create a new database, I associate it with the admin login.
I grant only read acces to the simple user login.
But I can't connect to the database with the simple user login.
after some exchange with the helpdesk, it seems that I can only use the admin login.
The fact is, I'm pretty sure the concept worked on my old account, using two different login to access my database.
So here some questions.
In the control panel, what is the utility of the option "database users" ?
Are there really no way to connect to a database with 2 different login (so I really forgot how my old web site worked) ? --> I just verified with the management console, I can access to the database. So was it a bug ?
Thanks for your answers.
OK, I write because I need some explanations or more precision about MS SQL and login user.
I created two login account. One admin, other one simple user.
I created one database.
When I create a new database, I associate it with the admin login.
I grant only read acces to the simple user login.
But I can't connect to the database with the simple user login.
after some exchange with the helpdesk, it seems that I can only use the admin login.
The fact is, I'm pretty sure the concept worked on my old account, using two different login to access my database.
So here some questions.
In the control panel, what is the utility of the option "database users" ?
Are there really no way to connect to a database with 2 different login (so I really forgot how my old web site worked) ? --> I just verified with the management console, I can access to the database. So was it a bug ?
Thanks for your answers.