09-02-2007 7:56 AM
Hi all,
Suppose I have a Z..table haing name ZSTUDENT with fields ROLLNO, NAME, ADDRESS. I want to use authority-check stmt in my report which is using zstudent table..
Pleas clarify me with a complete example....
<b>Have ur ponts.</b>
Regards,
09-02-2007 12:37 PM
Check the below PDF Document and it has complete document
Thanks
Seshu
09-02-2007 11:30 AM
Hello Pradeep,
Do you want to have an authority-check on the table itself or the fields of the table?
By the way to create authority object refer to tcode use SU21.
Best regards,
09-02-2007 12:37 PM
Check the below PDF Document and it has complete document
Thanks
Seshu
09-02-2007 2:05 PM
Hi Pradeep..
I feel that you want to check that the user executing the report has access to read or write data to this table or not..
Do one thing.. Ask the basis guys to create an authority object for your table..
Now in your code, before the SELECT statement on this table, check the authority object.
CHECK authority-object 'xxxx'
ID 'yyyy' FIELD 'zzzz'. etc
ID 'ACTVT' FIELD '03'.
And before the INSERT, UPDATE, MODIFY statements, add the same check but with ACTVT value '02' or '01'.
Thanks and Best Regards,
Vikas Bittera.