Logon trigger error inserting in char field with '$' at the end

Question

Logon trigger error inserting in char field with '$' at the end

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323741 More actions · Answer 1

if you created a table that captures login info, then i think you need to GRANT INSERT ON [dbo].[rvvlogindata] TO PUBLIC so that any login would not fail inside the trigger.

i'd bet you a donut that login you mentioned doesn't have insert permissions to the table, and thus fails inside the trigger.

the error log would have the details, and it would probably say object [dbo].[rvvlogindata]( does not exist or you don't have permission to perform this action for the offending user.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

richard.vanveen SSC Eights! Points: 833 More actions · Answer 2

Thanks for the suggestion, but I had already granted insert to public, which is why all the logins can login but the one with special character in the name(possibly due to the $ being the last character?)