Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Region Display Selector

Gus COct 2 2015 — edited Oct 5 2015

Apex 5

Universal Theme

I have a region display selector half way down my page.

Whenever I click on the selector, I get get the correct region selected, but I am also

taken back to the top of the page.

Is there anyway to stop this, ie, stay on the same point of the page

Regards

Gus
This post has been answered by timothyscottchambers-Oracle on Oct 2 2015
Jump to Answer

Comments

Your GRANT ALL to test for all tables provides that account with access to all schemas on the server.
If you want to keep test out of salaries but allow others, you first need to set up the grants on the employees.salaries table before blocking the test account. You have to do the equivalent of building the fence around the property before barring them or there is no way to block their access.
https://dev.mysql.com/doc/refman/8.0/en/grant.html#grant-column-privileges

dvohra21

The SELECT privilege can only be revoked at the level it is granted. Use
mysql> REVOKE SELECT ON employees.salaries FROM 'test'@'%';

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 2 2015
Added on Oct 2 2015
#apex-discussions
2 comments
2,881 views