You administer a Microsoft SQL Server 2012 database. The database has a table named Customers
owned by UserA and another table named Orders owned by UserB. You also have a stored
procedure named GetCustomerOrderInfo owned by UserB. GetCustomerOrderInfo selects data from
both tables.
You create a new user named UserC.
You need to ensure that UserC can call the GetCustomerOrderInfo stored procedure. You also need
to assign only the minimum required permissions to UserC.
Which permission or permissions should you assign to UserC? Choose all that apply.
A.
The Select permission on Customers
B.
The Execute permission on GetCustomerOrderInfo
C.
The Take Ownership permission on Customers
D.
The Control permission on GetCustomerOrderInfo
E.
The Take Ownership permission on Orders
F.
The Select permission on Orders
Explanation:
http://msdn.microsoft.com/en-us/library/ms188676.aspx
http://stackoverflow.com/questions/2212044/sql-server-how-to-permission-schemas
http://sqlservercentral.com/blogs/steve_jones/2012/03/14/ownership-chains-in-sql-server
I don’t believe this answer is correct. I’m not sure about ownership chaining, but I do know that if a user does not have select permission on a table, but does have execute permission on a stored procedure that selects from that table, then the user is able to execute the stored procedure.
Hence, I would go with B only
0
0
Table customers is not owned by UserB who is owning SP and Order table. So A, B is the right set of answer.
0
0
Logically, the correct answer is A and B. But the question says the stored procedure selects data from BOTH the tables CUSTOMER and ORDERS. Now, userb owns ORDERS but not CUSTOMER. So in order to create the said stored procedure in the first place, userb has to have SELECT permission on the CUSTOMER table, otherwise SQL wont create the procedure failing with a permission related error. Granted the stored procedure is created, userb now has SELECT permission on both the tables, in which case, the execute permission would suffice for userc to successfully execute the stored procedure without explicitly providing him SELECT permission on the CUSTOMER table.
I hope this clarifies. Someone tell me the RIGHT answer 🙁
0
0
Correction – I originally tried this on table objects owned by dbo (default). If this is the case, then all that is needed is execute permission on the sp that access the sp.
However, if the table is an a schema owned by another user, then the UserC would need explicit select permission on the table as well as execute on the stored procedure.
So, my corrected answer: A,C,F
0
0
my bad.. a, b,
oops again… You dont have to give select permission to the Orders table because of ownership chain
0
0
I adore reading through and I think this website got some truly useful stuff on it! .
http://www.bastcilkdoptb.com/
0
0
Don’t bother, he needs the traffic to sell the domain
0
0
A – B
0
0
This question still actual in real test. I try A, B, but i dont know if it is correct.
New questions from Gonzalez is realy from actual exam test, i can confirm it.
0
0
A – B
0
0
Please visit the sites we follow, like this 1, because it represents our picks through the web.
0
0
Sites of interest we’ve a link to
0
0
here are some links to sites that we link to simply because we assume they’re really worth visiting
0
0
below you will locate the link to some web sites that we think you ought to visit
0
0
Every once inside a while we select blogs that we read. Listed beneath are the newest websites that we pick
0
0
Every once inside a though we pick out blogs that we study. Listed below would be the newest sites that we opt for
0
0
very couple of web sites that come about to be detailed beneath, from our point of view are undoubtedly nicely really worth checking out
0
0
we came across a cool site that you might take pleasure in. Take a search should you want
0
0
Wonderful story, reckoned we could combine a few unrelated information, nevertheless seriously worth taking a appear, whoa did one understand about Mid East has got a lot more problerms as well
0
0
Here are a number of the internet sites we advise for our visitors
0
0
we prefer to honor many other world wide web sites on the internet, even though they arent linked to us, by linking to them. Underneath are some webpages worth checking out
0
0
Hey, Guys, I would also recommend Galassi & Ortolani here, they have been making special valves since years. The have a wide range of products, comprising: diaphragm valves, pinch valves, butterfly valves, ball valves, gate valves, check valves & pneumatic actuators. Here is their website: http://www.galassiortolani.com/category/butterfly-valves/
0
0