T-SQL query on how a login has access to sp_helpuser stored procedureHow do I perform an IF…THEN in an SQL SELECT?How to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?SQL Server: Query fast, but slow from procedureInserting multiple rows in a single SQL query?Insert results of a stored procedure into a temporary tableFunction vs. Stored Procedure in SQL ServerHow to check if a stored procedure exists before creating itHow do I UPDATE from a SELECT in SQL Server?How do I insert multiple rows WITHOUT repeating the “INSERT INTO dbo.Blah” part of the statement?
How can I get through very long and very dry, but also very useful technical documents when learning a new tool?
Is there a good way to store credentials outside of a password manager?
Coordinate position not precise
Teaching indefinite integrals that require special-casing
If you attempt to grapple an opponent that you are hidden from, do they roll at disadvantage?
Is there a problem with hiding "forgot password" until it's needed?
when is out of tune ok?
What does this 7 mean above the f flat
Can I Retrieve Email Addresses from BCC?
Why did Kant, Hegel, and Adorno leave some words and phrases in the Greek alphabet?
Why is delta-v is the most useful quantity for planning space travel?
How does it work when somebody invests in my business?
Is a roofing delivery truck likely to crack my driveway slab?
Hide Select Output from T-SQL
What is the intuitive meaning of having a linear relationship between the logs of two variables?
How do we know the LHC results are robust?
Dot above capital letter not centred
Why is `const int& k = i; ++i; ` possible?
I'm in charge of equipment buying but no one's ever happy with what I choose. How to fix this?
Was the picture area of a CRT a parallelogram (instead of a true rectangle)?
How do I rename a LINUX host without needing to reboot for the rename to take effect?
Is there an Impartial Brexit Deal comparison site?
Products and sum of cubes in Fibonacci
Should my PhD thesis be submitted under my legal name?
T-SQL query on how a login has access to sp_helpuser stored procedure
How do I perform an IF…THEN in an SQL SELECT?How to return only the Date from a SQL Server DateTime datatypeHow to check if a column exists in a SQL Server table?SQL Server: Query fast, but slow from procedureInserting multiple rows in a single SQL query?Insert results of a stored procedure into a temporary tableFunction vs. Stored Procedure in SQL ServerHow to check if a stored procedure exists before creating itHow do I UPDATE from a SELECT in SQL Server?How do I insert multiple rows WITHOUT repeating the “INSERT INTO dbo.Blah” part of the statement?
I've been searching for this for hours but without any success, so my problem is that i have a login in SQL Server who has access to sp_helpuser, but I have checked the roles and the login and can't find it granted directly.
Could you help me please to find how a login inherits sp_helpuser, through which role or other stored procedure?
Thank you very much
sql-server tsql ssms edited Mar 8 at 10:31
marc_s
583k13011241270
asked Mar 8 at 10:13
HussanasHussanas
32
add a comment |
I've been searching for this for hours but without any success, so my problem is that i have a login in SQL Server who has access to sp_helpuser, but I have checked the roles and the login and can't find it granted directly.
Could you help me please to find how a login inherits sp_helpuser, through which role or other stored procedure?
Thank you very much
sql-server tsql ssms edited Mar 8 at 10:31
marc_s
583k13011241270
asked Mar 8 at 10:13
HussanasHussanas
32
1
I suppose the better question is, why is it a problem the user can usesp_helpuser?
– Larnu
Mar 8 at 10:22
add a comment |
I've been searching for this for hours but without any success, so my problem is that i have a login in SQL Server who has access to sp_helpuser, but I have checked the roles and the login and can't find it granted directly.
Could you help me please to find how a login inherits sp_helpuser, through which role or other stored procedure?
Thank you very much
sql-server tsql ssms edited Mar 8 at 10:31
marc_s
583k13011241270
asked Mar 8 at 10:13
HussanasHussanas
32
I've been searching for this for hours but without any success, so my problem is that i have a login in SQL Server who has access to sp_helpuser, but I have checked the roles and the login and can't find it granted directly.
Could you help me please to find how a login inherits sp_helpuser, through which role or other stored procedure?
Thank you very much
sql-server tsql ssms sql-server tsql ssms edited Mar 8 at 10:31
marc_s
583k13011241270
asked Mar 8 at 10:13
HussanasHussanas
32
edited Mar 8 at 10:31
marc_s
583k13011241270
asked Mar 8 at 10:13
HussanasHussanas
32
edited Mar 8 at 10:31
marc_s
583k13011241270
edited Mar 8 at 10:31
marc_s
583k13011241270
edited Mar 8 at 10:31
marc_s
583k13011241270
583k13011241270
asked Mar 8 at 10:13
HussanasHussanas
32
asked Mar 8 at 10:13
HussanasHussanas
32
asked Mar 8 at 10:13
HussanasHussanas
32
32
1
I suppose the better question is, why is it a problem the user can usesp_helpuser?
– Larnu
Mar 8 at 10:22
add a comment |
1
I suppose the better question is, why is it a problem the user can usesp_helpuser?
– Larnu
Mar 8 at 10:22
1
1
I suppose the better question is, why is it a problem the user can use
sp_helpuser?– Larnu
Mar 8 at 10:22
I suppose the better question is, why is it a problem the user can use
sp_helpuser?– Larnu
Mar 8 at 10:22
add a comment |
1 Answer
1
active
oldest
votes
This link on sp_helpuser states:
Permissions
Requires membership in the public role.
Information returned is subject to restrictions on access to metadata. Entities on which the principal has no permission do not appear. For more information, see Metadata Visibility Configuration.
answered Mar 8 at 10:20
Pavel NefyodovPavel Nefyodov
7301825
1
"Read the fabulous online documentation" almost always helps!
– marc_s
Mar 8 at 10:31
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55061006%2ft-sql-query-on-how-a-login-has-access-to-sp-helpuser-stored-procedure%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
This link on sp_helpuser states:
Permissions
Requires membership in the public role.
Information returned is subject to restrictions on access to metadata. Entities on which the principal has no permission do not appear. For more information, see Metadata Visibility Configuration.
answered Mar 8 at 10:20
Pavel NefyodovPavel Nefyodov
7301825
1
"Read the fabulous online documentation" almost always helps!
– marc_s
Mar 8 at 10:31
add a comment |
This link on sp_helpuser states:
Permissions
Requires membership in the public role.
Information returned is subject to restrictions on access to metadata. Entities on which the principal has no permission do not appear. For more information, see Metadata Visibility Configuration.
answered Mar 8 at 10:20
Pavel NefyodovPavel Nefyodov
7301825
1
"Read the fabulous online documentation" almost always helps!
– marc_s
Mar 8 at 10:31
add a comment |
This link on sp_helpuser states:
Permissions
Requires membership in the public role.
Information returned is subject to restrictions on access to metadata. Entities on which the principal has no permission do not appear. For more information, see Metadata Visibility Configuration.
answered Mar 8 at 10:20
Pavel NefyodovPavel Nefyodov
7301825
This link on sp_helpuser states:
Permissions
Requires membership in the public role.
Information returned is subject to restrictions on access to metadata. Entities on which the principal has no permission do not appear. For more information, see Metadata Visibility Configuration.
answered Mar 8 at 10:20
Pavel NefyodovPavel Nefyodov
7301825
answered Mar 8 at 10:20
Pavel NefyodovPavel Nefyodov
7301825
answered Mar 8 at 10:20
Pavel NefyodovPavel Nefyodov
7301825
answered Mar 8 at 10:20
Pavel NefyodovPavel Nefyodov
7301825
7301825
1
"Read the fabulous online documentation" almost always helps!
– marc_s
Mar 8 at 10:31
add a comment |
1
"Read the fabulous online documentation" almost always helps!
– marc_s
Mar 8 at 10:31
1
1
"Read the fabulous online documentation" almost always helps!
– marc_s
Mar 8 at 10:31
"Read the fabulous online documentation" almost always helps!
– marc_s
Mar 8 at 10:31
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55061006%2ft-sql-query-on-how-a-login-has-access-to-sp-helpuser-stored-procedure%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
I suppose the better question is, why is it a problem the user can use
sp_helpuser?– Larnu
Mar 8 at 10:22