| Computers Forum Index » Computer - Databases - Sybase » select * from master..sysprotects... |
|
Page 1 of 1 |
|
| Author |
Message |
| Bkiddo... |
 Posted: Wed Nov 04, 2009 6:58 pm |
|
|
|
Guest
|
Is different the information you get if you run:
select * from master..sysprotects
than the one you obtain from:
select * from sysprotects ?
I need to ask because I don't have data base to test them, thanks, |
|
|
| Back to top |
|
|
|
| Bret_Halford... |
| Posted: Wed Nov 04, 2009 11:24 pm |
|
|
|
Guest
|
On Nov 4, 11:58 am, Bkiddo <beatriz.du... at (no spam) gmail.com> wrote:
Quote: Is different the information you get if you run:
select * from master..sysprotects
than the one you obtain from:
select * from sysprotects ?
I need to ask because I don't have data base to test them, thanks,
These would be the same if the user was currently in the master
database,
otherwise different. "select * from sysprotects" will get the results
from
the sysprotects table in the database the user is using. |
|
|
| Back to top |
|
|
|
|
