Skip to Main Content
Forums

Database Software

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!

How to restrict grant connect through with Data Vault

Jeff ChircoDec 19 2012
I need to restrict the ability to grant proxy privileges in the database. This is the statement: alter user USER_A grant connect through USER_B;

I tried creating this rule that looks at the sql text for %CONNECT THROUGH% in the statement and then added it to the "Can Maintain Own Account" Rule Set which is attached to the Alter System command but it doesn't appear to be working. How can I get this working? Is my rule that I created correct. Ultimately what I want to do is allow proxies to be created for most users but just restrict only certain special users.
BEGIN
dbms_macadm.delete_rule(rule_name => 'NO_PROXY_PRIVILEGES');
DBMS_MACADM.CREATE_RULE(rule_name => 'NO_PROXY_PRIVILEGES',
rule_expr => 'INSTR(UPPER(DVSYS.DV_SQL_TEXT),''%CONNECT THROUGH%'') = 0');
END;
I am running Oracle 11.2.0.2 Enterprise on Windows Server 2008R2
Thank you.

Comments

785636

Hello,

I want to learn more about what is the process to contribute to MySQL team as C++ developer, Thanks.

Hello,

I want to learn more about what is the process to contribute to MySQL team as C++ developer, Thanks.

Hello,

so sorry for the delay in responding.

You first need to sign a Oracle Contribution Agreement (OCA) - http://www.oracle.com/technetwork/community/oca-486395.html in order you to get in the list of Oracle's contributors.

You need to create an account in our bug system: https://bugs.mysql.com/ .

Once those two steps are done, you can contribute either by submitting a bug in our bug system of using the GitHub (please provide your GitHub name when you submit the OCA).

These are the process steps, if you have any technical questions, then please share it and I will help you to get an answer.

thank you,

-Lenka

fareed shah

Contributing code to MySQL, which is an open-source relational database management system, serves several important purposes:

1. **Improving MySQL's Functionality and Performance:**

  • By contributing code, developers can enhance the functionality and performance of MySQL. This can include adding new features, optimizing existing ones, or fixing bugs.

2. **Community Collaboration:**

  • MySQL is developed collaboratively by a community of contributors. Contributing code allows developers to actively participate in this community, share their expertise, and collaborate with other like-minded individuals.

3. **Addressing Issues and Bugs:**

  • Open-source projects often benefit from the diverse skills of contributors who can identify and fix issues or bugs. By contributing code, developers help ensure the stability and reliability of MySQL.

4. **Keeping MySQL Up-to-Date:**

  • Technology evolves rapidly, and MySQL needs to stay current to meet the demands of modern applications. Contributing code helps keep MySQL up-to-date with the latest industry standards, best practices, and technological advancements.

5. **Customization and Specialized Features:**

  • Organizations or individuals with specific needs can contribute code to MySQL to implement custom features or functionalities tailored to their requirements. This flexibility is a key advantage of open-source software.

6. **Quality Assurance:**

  • A large and active community of contributors helps in identifying and fixing issues through rigorous testing and quality assurance processes. This collective effort enhances the overall reliability of MySQL.

7. **Learning and Skill Development:**

  • Contributing to an open-source project like MySQL provides developers with valuable learning opportunities. It allows them to work on real-world projects, understand the intricacies of a complex system, and improve their coding skills.

8. **Building a Reputation:**

  • Actively contributing to a widely used and respected open-source project can enhance a developer's professional reputation. It showcases their skills, commitment, and ability to work collaboratively within a community.

9. **Supporting the Open-Source Ecosystem:**

  • Contributing to MySQL aligns with the principles of the open-source ecosystem. It promotes the sharing of knowledge, code, and resources for the benefit of the broader community.

In summary, contributing code to MySQL is not just about adding features or fixing bugs; it's about actively participating in a community-driven effort to create a robust, efficient, and continually evolving database management system. It's a collaborative process that brings together developers with diverse skills and perspectives to improve and maintain a critical piece of open-source infrastructure. CHECK

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

Post Details

Locked on Jan 16 2013
Added on Dec 19 2012
#11g, #database-security, #database-security-general
0 comments
239 views