The effect is that it will be selectable from connectors of any company.
Redpeaks will gather information with the following means:
Stored procedures:
Tables:
Example of role creation:
If you want to create a SAP user with Read access on a table (t1 in this example) of SAPSR3DB schema, you will have to follow the following:
USER MASTER GO CREATE ROLE test_role GO
sp_addlogin testuser, testuser, SAPSR3DB GO USE SAPSR3DB GO sp_adduser testuser , testuser GO
GRANT SELECT on t1 TO test_role GO
USE MASTER GO GRANT ROLE test_role TO testuser GO sp_modifylogin testuser, "add default role", test_role GO
GRANT EXECUTE ON my_procedure TO role