参考文档：

https://answers.sap.com/questions/6236648/create-read-only-user-in-oracle-10204.html

1) create user audit_ro identified by Cbest2023;

2) Create role READONLYROLE; { PPMROLE is the role name which will be later assigned to the user PPMTEST}

3) Grant CONNECT to READONLYROLE; { CONNECT role allows the user to connect to oracle database}

4) Grant SELECT_CATALOG_ROLE to READONLYROLE; { SELECT_CATALOG_ROLE role allows the user to view the oracle data dictionary}

5) GRANT SELECT ANY TABLE to READONLYROLE; { "SELECT ANY TABLE" privilege allows the user to view the table which is present in the SAP schema}

6) Grant READONLYROLE to audit_ro; { Assigning the role PPMROLE to the user PPMTEST}

7) COMMIT;