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 |
|
irislaw
Starting Member
7 Posts |
 Posted - 2006-12-01 : 13:23:16
|
| I am using an ERP system with SQL Server as the back end. Yesterday, I tried to grant the access to myself on one table, but somehow it didn't work successfully. I dunno if it is because of this, it affect other users's security. When they tried to login to the ERP system, the got the following error message:229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'Grant', database 'HEI', owner 'dbo'Anyone knows how to fix it? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-12-04 : 00:13:46
|
| post the tsql you used to grant select on yourselfby any chance did you issue a revoke after the failure to grant?--------------------keeping it simple... |
 |
|
|
|
|
|
Permission error