Business Intelligence || SQL Interview Questions || Fresher Jobs Bangalore || Data Science Jobs : November 2016

OBIEE Section Level Permissions

I have created two reports and placed those reports in Test Dashboard.

I have place both the reports in two different section as seen in the screenshot below.

From weblogic user if I run the dashboard, both the reports will run.

I can see that in Manage sessions section in Administration Tab.

Logs available in Manage Session section:

We can see, there are two reports ran for weblogic user.

Now, To achieve our scenario, for user Prasad, I am giving section level permission, for second section (Sales by Products report) I am giving access denied.

Now, I am logging in as user Prasad and I will run the Test Dashboard.

Now if we see the logs in Manage sessions section, we can see only one report hit the database.

other report didn't run at all.

If we have, multiple users, we can add those users to either catalog groups and customized roles and we can give permissions as per the requirement.

Happy Learning !!!!!!!

OBIEE Section Level Permissions

I have created two reports and placed those reports in Test Dashboard.

I have place both the reports in two different section as seen in the screenshot below.

From weblogic user if I run the dashboard, both the reports will run.

I can see that in Manage sessions section in Administration Tab.

Logs available in Manage Session section:

We can see, there are two reports ran for weblogic user.

Now, To achieve our scenario, for user Prasad, I am giving section level permission, for second section (Sales by Products report) I am giving access denied.

Now, I am logging in as user Prasad and I will run the Test Dashboard.

Now if we see the logs in Manage sessions section, we can see only one report hit the database.

other report didn't run at all.

If we have, multiple users, we can add those users to either catalog groups and customized roles and we can give permissions as per the requirement.

Happy Learning !!!!!!!

Useful SQL Statement DBA Beginners

Statement for creating user in Oracle SQL Database:

SQL> create user username identified by password;

e.g : SQL> create user prasad identified by pras123;

Statement for giving permissions to Oracle SQL Database:

SQL> grant connect ,resource to username;

e.g : SQL> grant connect ,resource to prasad;

Statement for unlocking user account in Oracle SQL Database:

SQL>alter user username account UNLOCK;

e.g : SQL>alter user prasad account UNLOCK;