Click here to Skip to main content
15,850,606 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQL SERVER STORE PROCEDURE Pin
Richard Deeming28-Apr-22 5:34
mveRichard Deeming28-Apr-22 5:34 
AnswerRe: SQL SERVER STORE PROCEDURE Pin
Mycroft Holmes28-Apr-22 12:59
professionalMycroft Holmes28-Apr-22 12:59 
GeneralRe: SQL SERVER STORE PROCEDURE Pin
jschell8-May-22 9:07
jschell8-May-22 9:07 
QuestionGiven two dates, count the number of dates in the range that is within month X Pin
Jame_T13-Apr-22 4:43
Jame_T13-Apr-22 4:43 
AnswerRe: Given two dates, count the number of dates in the range that is within month X Pin
Craig Robbins13-Apr-22 5:10
Craig Robbins13-Apr-22 5:10 
AnswerRe: Given two dates, count the number of dates in the range that is within month X Pin
CHill6020-Apr-22 8:04
mveCHill6020-Apr-22 8:04 
QuestionBest practice for creating a limited access ms-sql user ? Pin
David Mujica12-Apr-22 12:12
David Mujica12-Apr-22 12:12 
AnswerRe: Best practice for creating a limited access ms-sql user ? Pin
jschell8-May-22 9:11
jschell8-May-22 9:11 
Your description seems to be going backwards.

What you should be doing.

First create the user.
Second give it access to the specific database.

Until you give it access it should not be able to do anything. Which is why your description seems off. Seems to suggest that you created it with access to everything and now you want to restrict that access. So whatever you did to create it in the first place is wrong.
QuestionMysql How to sort row ORDER BY another query? Pin
Zac Ang3-Apr-22 11:45
Zac Ang3-Apr-22 11:45 
SuggestionRe: Mysql How to sort row ORDER BY another query? Pin
Richard Deeming3-Apr-22 22:46
mveRichard Deeming3-Apr-22 22:46 
AnswerRe: Mysql How to sort row ORDER BY another query? Pin
CHill606-Apr-22 3:57
mveCHill606-Apr-22 3:57 
QuestionFilter data before lookup(join) two collections in mongodb Pin
85510-Mar-22 5:20
85510-Mar-22 5:20 
Rant[REPOST] Filter data before lookup(join) two collections in mongodb Pin
Richard Deeming10-Mar-22 5:51
mveRichard Deeming10-Mar-22 5:51 
GeneralRe: [REPOST] Filter data before lookup(join) two collections in mongodb Pin
85510-Mar-22 6:23
85510-Mar-22 6:23 
GeneralRe: [REPOST] Filter data before lookup(join) two collections in mongodb Pin
Richard Deeming10-Mar-22 7:26
mveRichard Deeming10-Mar-22 7:26 
Question[MySQL] Failed to set datadir Pin
chipp_zanuff1-Mar-22 8:54
chipp_zanuff1-Mar-22 8:54 
AnswerRe: [MySQL] Failed to set datadir Pin
Victor Nijegorodov1-Mar-22 9:39
Victor Nijegorodov1-Mar-22 9:39 
GeneralRe: [MySQL] Failed to set datadir Pin
chipp_zanuff1-Mar-22 18:42
chipp_zanuff1-Mar-22 18:42 
GeneralRe: [MySQL] Failed to set datadir Pin
Victor Nijegorodov1-Mar-22 23:42
Victor Nijegorodov1-Mar-22 23:42 
AnswerRe: [MySQL] Failed to set datadir Pin
Richard MacCutchan1-Mar-22 23:45
mveRichard MacCutchan1-Mar-22 23:45 
GeneralRe: [MySQL] Failed to set datadir Pin
chipp_zanuff2-Mar-22 1:35
chipp_zanuff2-Mar-22 1:35 
GeneralRe: [MySQL] Failed to set datadir Pin
Richard MacCutchan2-Mar-22 1:47
mveRichard MacCutchan2-Mar-22 1:47 
GeneralRe: [MySQL] Failed to set datadir Pin
chipp_zanuff3-Mar-22 0:37
chipp_zanuff3-Mar-22 0:37 
GeneralRe: [MySQL] Failed to set datadir Pin
Richard MacCutchan3-Mar-22 0:44
mveRichard MacCutchan3-Mar-22 0:44 
GeneralRe: [MySQL] Failed to set datadir Pin
chipp_zanuff3-Mar-22 1:30
chipp_zanuff3-Mar-22 1:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.