Saturday, February 4, 2012

To Restrict access to database during particular time period

We can restrict access to any database during particular time period  for any user.
Open the Administrator Tool, Go to Manage -> security.
In Security Manager, click on Users in left pane, then  on right pane select the user and open properties(right click on user and select properties).
Then click on Permission Tab.




















In the User/Group Permissions dialog box, click the Query Limits tab and expand the dialog box to view all columns then to restrict access to a database during particular time periods, in the Restrict column, click the ellipsis button.







In the Restrictions dialog box, perform the following steps: 
1. To select a time period, click the stat time and drag t end time.
2. To expilicitly allo access, click Allow.
3. To explicitly disallow access, click Disallow.

In my case, I selected paint database(clicked on the ellipsis located beside to paint ) and restrict access to that database from 6am to noon on every Monday for that user.
















Then click OK. Restart the OBI server services and check it presentation services by login  as that user.

No comments:

Post a Comment

Thanks for your comment.