Click here to Skip to main content
16,019,018 members
Home / Discussions / Database
   

Database

 
QuestionSQL SERVER STORE PROCEDURE Pin
Luis M. Rojas28-Apr-22 3:45
Luis M. Rojas28-Apr-22 3:45 
AnswerRe: SQL SERVER STORE PROCEDURE Pin
Richard Deeming28-Apr-22 4:34
mveRichard Deeming28-Apr-22 4:34 
AnswerRe: SQL SERVER STORE PROCEDURE Pin
Mycroft Holmes28-Apr-22 11:59
professionalMycroft Holmes28-Apr-22 11:59 
GeneralRe: SQL SERVER STORE PROCEDURE Pin
jschell8-May-22 8:07
jschell8-May-22 8:07 
QuestionGiven two dates, count the number of dates in the range that is within month X Pin
Jame_T13-Apr-22 3:43
Jame_T13-Apr-22 3:43 
AnswerRe: Given two dates, count the number of dates in the range that is within month X Pin
Craig Robbins13-Apr-22 4:10
Craig Robbins13-Apr-22 4:10 
AnswerRe: Given two dates, count the number of dates in the range that is within month X Pin
CHill6020-Apr-22 7:04
mveCHill6020-Apr-22 7:04 
QuestionBest practice for creating a limited access ms-sql user ? Pin
David Mujica12-Apr-22 11:12
David Mujica12-Apr-22 11:12 
Given:
1) Developing a WebService on a DMZ server which will connect back to corporate SQL2019 server.
2) There are lots of other databases on this server, however there will be only one database (DB_X) which these WebServices need to interact.
3) Assume user, WEBAPI_USER, is created.
Also executed: DENY VIEW ANY DATABASE TO WEBAPI_USER;
4) Now, that user cannot see any databases via MS SQL Server Studio, not even the DB_X database which has been granted access

Note: Kind of crazy because if you run the query: SELECT * FROM SYSOBJECTS WHERE XTYPE = 'U', you will get a full list of all the tables. If done some research on this and it appears that WEBAPI_USER would need to become the owner of the databaase to see it in MSSS.

Question: What is everyone else doing to create a limited access MS-SQL user ?

Thank you in advance.
David
AnswerRe: Best practice for creating a limited access ms-sql user ? Pin
jschell8-May-22 8:11
jschell8-May-22 8:11 
QuestionMysql How to sort row ORDER BY another query? Pin
Zac Ang3-Apr-22 10:45
Zac Ang3-Apr-22 10:45 
SuggestionRe: Mysql How to sort row ORDER BY another query? Pin
Richard Deeming3-Apr-22 21:46
mveRichard Deeming3-Apr-22 21:46 
AnswerRe: Mysql How to sort row ORDER BY another query? Pin
CHill606-Apr-22 2:57
mveCHill606-Apr-22 2:57 
QuestionFilter data before lookup(join) two collections in mongodb Pin
85510-Mar-22 4:20
85510-Mar-22 4:20 
Rant[REPOST] Filter data before lookup(join) two collections in mongodb Pin
Richard Deeming10-Mar-22 4:51
mveRichard Deeming10-Mar-22 4:51 
GeneralRe: [REPOST] Filter data before lookup(join) two collections in mongodb Pin
85510-Mar-22 5:23
85510-Mar-22 5:23 
GeneralRe: [REPOST] Filter data before lookup(join) two collections in mongodb Pin
Richard Deeming10-Mar-22 6:26
mveRichard Deeming10-Mar-22 6:26 
Question[MySQL] Failed to set datadir Pin
chipp_zanuff1-Mar-22 7:54
chipp_zanuff1-Mar-22 7:54 
AnswerRe: [MySQL] Failed to set datadir Pin
Victor Nijegorodov1-Mar-22 8:39
Victor Nijegorodov1-Mar-22 8:39 
GeneralRe: [MySQL] Failed to set datadir Pin
chipp_zanuff1-Mar-22 17:42
chipp_zanuff1-Mar-22 17:42 
GeneralRe: [MySQL] Failed to set datadir Pin
Victor Nijegorodov1-Mar-22 22:42
Victor Nijegorodov1-Mar-22 22:42 
AnswerRe: [MySQL] Failed to set datadir Pin
Richard MacCutchan1-Mar-22 22:45
mveRichard MacCutchan1-Mar-22 22:45 
GeneralRe: [MySQL] Failed to set datadir Pin
chipp_zanuff2-Mar-22 0:35
chipp_zanuff2-Mar-22 0:35 
GeneralRe: [MySQL] Failed to set datadir Pin
Richard MacCutchan2-Mar-22 0:47
mveRichard MacCutchan2-Mar-22 0:47 
GeneralRe: [MySQL] Failed to set datadir Pin
chipp_zanuff2-Mar-22 23:37
chipp_zanuff2-Mar-22 23:37 
GeneralRe: [MySQL] Failed to set datadir Pin
Richard MacCutchan2-Mar-22 23:44
mveRichard MacCutchan2-Mar-22 23:44 

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.