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 |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2005-03-09 : 12:36:59
|
| Is there any query I can use to check the access permissions on the table about what user has select,update,delete for a table or is there any system sp i can use |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2005-03-09 : 13:00:39
|
| I tried with this sp_table_privileges table name but I couldn't see the login i use to login to the query analyzer |
 |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2005-03-09 : 14:34:20
|
| please can anybody assist me on this issue |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-03-09 : 16:21:02
|
| the login you used to log into query analyzer probably has "implied" permissions to this table. ie: sysadmin, dbo, member of a role that did appear on the list, etc...Are these what you're looking for?sp_helpusersp_helprolesp_helprolemember sp_helpsrvrolemembersp_helpsrvrolesp_helploginsBe One with the OptimizerTG |
|
|
|
|
|
|
Access permissions