Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-19 : 09:48:23
|
| Yogesh writes "1. A user is member of public role and sales role.Public role has the permissions to select on all the table,and sales role,which doesn't have a select permissions on some of the tables.Will that user be able to select from all tables ?Q 2Describe application role and explain a scenario when you will use it ?Q 3I have a SP names YourSP and have the a select stmt inside the SP. I also have a user named YourUser.What permissions i have give him for accessing the SP ?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-05-19 : 09:49:09
|
| Sorry for the delay everyone, I know you've been eagerly awaiting Yogesh's daily dose of exam questions. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-19 : 09:49:52
|
| Unless sales denies select permission rather than just not granting it then yes.oops.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-05-19 : 09:56:27
|
| Have you tried looking in the back of the book? Sometimes they have the answer there.CODO ERGO SUM |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-19 : 10:20:11
|
1. it depends which role he takes on2. [hint] the application role is the status of an employed person who is thinking of leaving his current employment and taking on someone else's post because the opportunity presents itself [/hint]3. youruser must have execute permission on yourspseriously, go to the msdn site, you will be able to get your answers there straight from microsoft and with examples and explanations, sometimes with pictures too... --------------------keeping it simple... |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-05-22 : 04:14:54
|
quote:
seriously, go to the msdn site, you will be able to get your answers there straight from microsoft and with examples and explanations, sometimes with pictures too
Q1 What is this msdn site you speak of? Please provide detailed answer immediately.Q2 How do I search Microsoft site for examples? Please give detailed written instructions and links and explain how to use linksQ3 Please explain all pictures on Microsft site |
|
|
|
Maux Maux
Starting Member
10 Posts |
Posted - 2006-05-22 : 12:19:09
|
| Handy link for Yogesh: www.TakeMyExamForMeDoItNowNowNowChopChop.com |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-22 : 23:42:20
|
priceless steve!  rotflol!--------------------keeping it simple... |
|
|
|
|
|
|
Permissions