Databases
--
Questions
--
Followers
Top Experts
Revoke Bind and Execute rights on all packages under NULLID schema for PUBLIC
Hi All,
I want to revoke Bind and execute rights from PUBLIC for all packages created under NULLID schema.
I have written sql as :
db2 -x "select 'REVOKE BIND, EXECUTE ON PACKAGE NULLID.' || ltrim(rtrim(PKGNAME)) || ' FROM PUBLIC;' from syscat.packages where PKGSCHEMA='NULLID'" >> RevokePublicGrants.sql
After executing above sql I am getting necessary commands in "RevokePublicGrants.sql".
But as there is not much documentation available on NET about this ,
please confirm following things
1) Is the sql I m using is sufficient OR i need to add more things in that.
2) Will my application function correctly after execution of "RevokePublicGrants.sql".
I want to revoke Bind and execute rights from PUBLIC for all packages created under NULLID schema.
I have written sql as :
db2 -x "select 'REVOKE BIND, EXECUTE ON PACKAGE NULLID.' || ltrim(rtrim(PKGNAME)) || ' FROM PUBLIC;' from syscat.packages where PKGSCHEMA='NULLID'" >> RevokePublicGrants.sql
After executing above sql I am getting necessary commands in "RevokePublicGrants.sql".
But as there is not much documentation available on NET about this ,
please confirm following things
1) Is the sql I m using is sufficient OR i need to add more things in that.
2) Will my application function correctly after execution of "RevokePublicGrants.sql".
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Does any one has link or information which describe in detail about all Groups, rights and permissions.
I found following link:
1) http://www.databasejournal.com/features/db2/article.php/3075671/Preventing-Public-Access-to-the-DB2-Database.htm
I found following link:
1) http://www.databasejournal.com/features/db2/article.php/3075671/Preventing-Public-Access-to-the-DB2-Database.htm
it is really simple,
here goes:
db2 does not manage users and groups and passwords, it relies on the operating system for that.
inside db2 you grant permissions or roles to either groups or users of the operating system,
so if you want your user to have the same permissions in db2 as some existing group, you just add it to that group in the os level
a permission is a specific privilege to do some action, for example, execute a package
a role is a group of permissions that represent some logical job, for example, a dbadm has permissions to do everything is a given database
sysadm has permissions to do everything in the db2 instance
was that clear enough?
here goes:
db2 does not manage users and groups and passwords, it relies on the operating system for that.
inside db2 you grant permissions or roles to either groups or users of the operating system,
so if you want your user to have the same permissions in db2 as some existing group, you just add it to that group in the os level
a permission is a specific privilege to do some action, for example, execute a package
a role is a group of permissions that represent some logical job, for example, a dbadm has permissions to do everything is a given database
sysadm has permissions to do everything in the db2 instance
was that clear enough?
Hi Momi_sabag,
It is much clear now,
Thank you for the explanation regarding Users and Groups.
It is much clear now,
Thank you for the explanation regarding Users and Groups.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Databases
--
Questions
--
Followers
Top Experts
Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.