June 4, 2019 at 12:00 am
Comments posted to this topic are about the item Limiting Access
June 4, 2019 at 5:29 am
Nice question to start the day on, thanks Steve
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
June 4, 2019 at 7:53 am
Crafty question!
June 4, 2019 at 11:40 am
must drink coffee before answering questions!
---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know
June 4, 2019 at 4:57 pm
Silly me,
I interpreted the .... to represent a further list of Grants.
June 4, 2019 at 6:43 pm
Interesting question but not sure I agree with the answer. Seems to me there are two possible correct answers. We don't know if SallyDev was or was not granted select to DatabaseSizeInfo. The user was created prior to any of the code we saw and there may have been a user level permission granted already. So if SallyDev had already been given select access then answer #2 would also be correct. I think the question is a bit too ambiguous to answer this accurately. Great concept on a great topic though.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
June 7, 2019 at 4:29 am
You should assume no permissions other than those shown. If that's not the case, the question should provide more background.
October 4, 2019 at 12:12 am
Not exactly correct question. The right answer depends on assumption. We do not need to guess if other permissions were given to use or not. The question should state that
October 4, 2019 at 11:05 pm
You should not assume, guess, or expect other permissions.
October 10, 2019 at 4:33 pm
Even if she already had permission in her own right though via an additional GRANT to Sallydev, it would still do nothing and answer 2 would still not be true because she would retain access via the role, would she not?
Asking genuinely here because everyone seems confident and I'm not 100% on this. I got it right based on not assuming permissions, but I did consider that even if she DID have explicit permission nothing materially would change.
-------------------------------Oh no!
October 10, 2019 at 4:43 pm
Yes.
If she does not have any other permission, nothing changes. If she does, nothign changes, other than cleaner permission set for auditors.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply