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 |
|
skane
Starting Member
1 Post |
 Posted - 2004-12-08 : 06:54:51
|
| Hi!I am writing an application which accesses an MSSQL database and I need to retrieve a users access permissions to a specified table.The problem is which tables and field do query.Any help would be much appreciated. |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2004-12-08 : 07:09:40
|
| Have a look at the sp_helprotect system proc, or the sysprotects system table. Look them up in BOL for information about columns etc. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-08 : 21:36:06
|
quote:
Originally posted by skane
Hi!I am writing an application which accesses an MSSQL database and I need to retrieve a users access permissions to a specified table.The problem is which tables and field do query.Any help would be much appreciated.
why do you need to query this information? ask your dba for assistance.--------------------keeping it simple... |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2004-12-09 : 20:02:50
|
| Speaking of simple...A student is taking a Physics test in school and the question is, "Using a barometer, how would you determine the height of a building?"The expected answer is to measure the pressures at the top and bottom of the building and plug the number into a known formula and compute.Student writes down:I'd go to the owner of the building and tell him, "This barometer is worth about $1,000.00 US and I will give it to you if you'll tell me the height of this building."The professor calls the student aside and says, "You need to show an application of physics as part of your answer. Try again."The student crosses out the original answer and writes, "I'd climb to the top of the building. Then I'd drop the barometer off and measure how long it takes for it to hit the ground and then calculate the distance using the formula (distance) = (time) * (acceleration).""Simple is as simple does", my Mama always told me. |
|
|
|
|
|
|
Retrieve Users Permissions for a Table