top of page

How to export permission set from database in IFS Applications

  • Writer: Rumesh Aponso (RMAX)
    Rumesh Aponso (RMAX)
  • Nov 5, 2024
  • 1 min read

Updated: Nov 13, 2024

APPS75

BEGIN
   -- Call the procedure
   Security_SYS.Export_Role__(security_permissions_         => :security_permissions_,
                              count_                        => :count_,
                              role_                         => 'IFSINFO',
                              include_presentation_objects_ => 'TRUE',
                              include_database_objects_     => 'TRUE',
                              include_activities_           => 'TRUE',
                              comment_define_               => 'FALSE',
                              requested_string_             => 1,
                              include_role_grants_          => 'TRUE');
END;

APPS10

BEGIN
  -- Call the procedure
  Security_SYS.Export_Role__(string_                       => :string_,
                             role_                         => 'IFSINFO',
                             include_presentation_objects_ => 'TRUE',
                             include_database_objects_     => 'TRUE',
                             include_activities_           => 'TRUE',
                             include_projections_          => 'TRUE',
                             comment_define_               => 'FALSE', -- If TRUE, the top most DEFINE blocks are commented
                             include_role_grants_          => 'TRUE'); -- LAST Grant section
END;

Comments


Copyright © 2025 RMAXOneNote

  • Online CV
  • LinkedIn
  • Youtube
  • GitHub
  • Blogger
bottom of page