User Access Database - Best practise
-
I am trying to document a system that I have taken over it is a single website with 3 database connections. The access to the database is via a single SQL Server login and it has the minimal access that is required for the site. My question is; each database has the same logon should they have different logon names for the database? Thanks Simon
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
My door key fits in the front door and in the back door; it may not be as safe as two keys, but it is convenient. OTOH, there's little of value here, so the risc of something happening is low.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
-
I am trying to document a system that I have taken over it is a single website with 3 database connections. The access to the database is via a single SQL Server login and it has the minimal access that is required for the site. My question is; each database has the same logon should they have different logon names for the database? Thanks Simon
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
Why does it matter?
Wrong is evil and must be defeated. - Jeff Ello
-
My door key fits in the front door and in the back door; it may not be as safe as two keys, but it is convenient. OTOH, there's little of value here, so the risc of something happening is low.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
Why would two keys be safer? You only need to break into one door to access the house.
Wrong is evil and must be defeated. - Jeff Ello
-
Why would two keys be safer? You only need to break into one door to access the house.
Wrong is evil and must be defeated. - Jeff Ello
That's because my example is not perfect; if it were two houses it would be more in line with the multiple databases. I do not buy locks based on best practices, but rather on the risc versus the damage.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
-
That's because my example is not perfect; if it were two houses it would be more in line with the multiple databases. I do not buy locks based on best practices, but rather on the risc versus the damage.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
Agreed
Wrong is evil and must be defeated. - Jeff Ello
-
Why does it matter?
Wrong is evil and must be defeated. - Jeff Ello
Wasn't sure if it was a problem so thought I'd ask a question. Looks like from yours and Eddys response that there is not really risk with it so I am not going to change it.
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
-
My door key fits in the front door and in the back door; it may not be as safe as two keys, but it is convenient. OTOH, there's little of value here, so the risc of something happening is low.
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
Thank Eddy your analogy made sense :thumbsup:
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
-
Wasn't sure if it was a problem so thought I'd ask a question. Looks like from yours and Eddys response that there is not really risk with it so I am not going to change it.
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
If you plan to split the databases in the future there might be a point to it. Or if you want to give different people different access, but there are easier ways to achieve that.
Wrong is evil and must be defeated. - Jeff Ello
-
If you plan to split the databases in the future there might be a point to it. Or if you want to give different people different access, but there are easier ways to achieve that.
Wrong is evil and must be defeated. - Jeff Ello
No the databases are already split into 3 Users Data Log I was asked if there was merit to different logons for the website to the databases (via services) but couldn't find a suitable answer so thought I'd ask her as someone may know of a good practise or had experience.
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON
-
Thank Eddy your analogy made sense :thumbsup:
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON