meta user
network profile
| bio | website | |
|---|---|---|
| location | New Zealand | |
| age | ||
| visits | member for | 1 year, 2 months |
| seen | 8 hours ago | |
| stats | profile views | 27 |
|
8h |
awarded | Citizen Patrol |
|
8h |
comment |
Why does fn_my_permissions return empty rowset? @AaronBertrand ok, I created a new question dba.stackexchange.com/questions/42668/… I also marked this current question for deletion. |
|
9h |
asked | Server permissions of an activation stored procedure of a Server Broker queue |
|
9h |
comment |
Why does fn_my_permissions return empty rowset? Aaron, every complex system has many interconnected components, and their relationship often can be not that obvious. Still they are all interconnected and affect each other and the end solution. I would like to understand the whole thing, from the beginning to end. It is not uncommon on SE that when you start digging a problem a new information is uncovered. I'd like to solve my problem. But I'd ALSO like to understand fn_my_permissions that returns different results. I'm not sure how to split the question. The parts are interconnected. |
|
9h |
comment |
Why does fn_my_permissions return empty rowset? 'Do you really expect that all server principals will automatically have all of those privileges?' I expect that the DBO user to have them. Yet it returns a single row. I do understand that we have Server Login and Database Users and that those are mapped to each other. However I don't understand how to get Server Permissions of a user for the purpose of the article I have linked. I have added some more info to the questions. Thank you for you help. |
|
9h |
revised |
Why does fn_my_permissions return empty rowset? added 2677 characters in body |
|
9h |
comment |
Why does fn_my_permissions return empty rowset? Thank you for the feedback. I have updated my questions. I would like to list all the server permission of a given user, not just one row. |
|
9h |
revised |
Why does fn_my_permissions return empty rowset? added 2677 characters in body |
|
10h |
comment |
Why does fn_my_permissions return empty rowset? @AaronBertrand those are good questions, thank you for them. I'll get back to you soon. |
|
10h |
revised |
Why does fn_my_permissions return empty rowset? added 6 characters in body |
|
10h |
asked | Why does fn_my_permissions return empty rowset? |
|
Apr 16 |
awarded | Popular Question |
|
Mar 12 |
awarded | Yearling |
|
Jan 11 |
awarded | Self-Learner |
|
Jun 20 |
accepted | Do auto created statistics indicate that you should build an index? |
|
May 2 |
awarded | Commentator |
|
May 2 |
comment |
Inaccurate 'Actual' row counts in parallel plan Itzik Ben-Gan's last name is misspelled. SE does not allow me to edit it as it's less than 6 chars edit. |
|
Apr 23 |
comment |
Do auto created statistics indicate that you should build an index? Thank you. Someone is suggesting here, that because there are a lot of auto created statistics in the database, the indexes are wrong or missing. I'm trying to validate this opinion. So this question is more about auto-created statistics rather than about updates. So given your answer, the question is, if an optimizer can benefit from these single-column statistics, should not we be building indexes instead? |
|
Apr 23 |
accepted | Cross-database call fails in a job but succeeds in SSMS |
|
Apr 23 |
asked | Do auto created statistics indicate that you should build an index? |
