web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... SqlStatementExecutePer...

Finance | Project Operations, Human Resources, ...

Unanswered

SqlStatementExecutePermission class ,Assert(),REvertAssert()

(0) Share

Report

Report

Posted on by MSDev

32

statement = userConnection.createStatement();

sqlPermission = new SqlStatementExecutePermission( sqlStatement);

sqlPermission.assert();

resultSet = statement.executeQuery(sqlStatement);

CodeAccessPermission::revertAssert();

Can Anyone tell me details about each line. Please give easy information about the all the classes and methods above

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Martin Dráb 237,795 Most Valuable Professional on at

Like (1)

Report

Please read the documentation first: Code Access Security. Then ask specific questions if you still don't understand something.

By the way, please always use Insert > Code (in the rich-formatting view) to paste source code to this forum.

Was this reply helpful? Yes No
MSDev 32 on at

Like (0)

Report

Hello Martin. i already read it but not understand it clearly. I am reading topic about "Executing Direct SQL statement"

Can you give me Detail about the function of SqlStatementExecutePermission class,sqlPermission.assert();

CodeAccessPermission::revertAssert(); by giving another example

Was this reply helpful? Yes No
Martin Dráb 237,795 Most Valuable Professional on at

Like (1)

Report

As the documentation says, assert() method is used to request the permissions, in this case permissions to execute direct SQL queries.

revertAssert() is used to remove the permissions. You already read the documentation, so you already know that it's optional and why.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 663 Most Valuable Professional

#2

André Arnaud de Cal... 540 Super User 2025 Season 2

#3

Sohaib Cheema 348 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans