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 |
simflex
Constraint Violating Yak Guru
327 Posts |
Posted - 2010-01-08 : 17:23:44
|
Greetings experts,This issue has stumped me now for days.I have a security page where page access permissions are set based on permission level.For instance, I have Permission Types from A1 to A11.Then Permission Levels from Admin to Guest.Guest Permissions and Reader Permissions are A10 and A11 Permission Types.On the Security Page, Access levels could be H for Hide, R for ReadOnly, W for Write and D for Delete.With the exception of those with H permission levels, any other user should be able to atlease view the contents of a page.So far, if anyone with Permission type of A10 or A11 attempts to log into the system, s/he is immediately kicked out of the system with the following custom message we created:Your session timed out as a result of inactivity. If you wish to continue, you must login again!This only happens to users with Permission Types of A10 or A11.If I change the permission Type to say A0, it works.This leads me to conclude that anytime the field PermissionType contains more than 2 characters, the user gets bounced out when they try to logon.That is why only users with A10 or A10 permissionTypes are getting bounced out.Can someone, please, please tell me if you know what could be causing this?I can provide some sampe code if needed.Thanks a lot. |
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-01-11 : 05:48:06
|
have you a procedure or routine in your code which is defined with a "2 character" input or output field....and a value is inadvertantly being truncated?unelsss you post your code, we can't help other than guess......the description of your problem is far to ovague. |
|
|
|
|
|
|
|