Post reply

Db level user is not having execute permission no db_owner

  • August 23, 2024 at 4:17 pm

    #4448718

    Dear all,

    we have a strange situation Db level [ user ]is not having execute permission also not having db_owner , having ddl read and write

    but in audit logs it is showing the same user had action_id/EX permission in audit logs how can this is possible.

    Thanks
    Naga.Rohitkumar

  • August 24, 2024 at 5:10 pm

    #4449776

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • August 26, 2024 at 5:22 am

    #4450005

    Dear SSC Guru ,

    we found the cause as the user level permission were having earlier so that user login can have execute permission on stored procedures

    later it was revoked so that when we run the audit log script in that it is showing EX for the respective login ( user in db) , but when we open the login (server level) and user ( db level) no permission are mapped to any SP .

    Thanks

    Naga.RohitKumar.

    Thanks
    Naga.Rohitkumar

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

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