db sh 26.Aug.13 12:30 AM a Web browser Applications Development All Releases All Platforms
I have one database which is very old, In this db there are three authors field's, in this field they have given default value for manager, sales person and role ex- "[abc]". There is one group in database, whose having this role. There is no reader field. Therefore everyone can see all documents which are created by other employee So now customer wants that everybody can not see all document, he wants that only those persons which are involved in that workflow only then can see the documents.
workflow like - New req->Manager-> sales person.
I am thinking that May be I can make one reader field and set that reader field in on button and give name the persons whose involve in that database but problem is there is one author field with role "[abc]" and it is assigned to group so that other persons are able to see the documents. I can not remove the role otherwise this will give the problem in old document.