 |  |  |  |  |  |  |  |
what is the difference between deny and revoke?
Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
hi everybody ...could anyone tell what is the difference between deny and revoke of privileges from a user.
0
#2 29 Days Ago
Permissions are cumulative and DENY takes precedence. REVOKE removes GRANT and DENY permissions previously assigned. Because all users are members of public, you should DENY permissions to public only when you want to prohibit access by all database users.
Hope that helps.
Hope that helps.
0
#3 28 Days Ago
Only the owner of the object has the permission/access on the object. Other users needs to be granted permissions by the owner/dba for access which is taken back by the REVOKE command.
If permission is not granted it means it is denied and there is no command to DENY any previlages.
If permission is not granted it means it is denied and there is no command to DENY any previlages.
Share your Knowledge.
0
#4 24 Days Ago
thank you so much to replay ...but i need more explanation with example ,i did not get it yet.
thanks in advance.
thanks in advance.
0
#6 18 Days Ago
Dear Friend!
example as below
this used to changes the permissions on database
this DCL(DATA CONTROL LANGUGE)STATEMENT
*)GRANT---THIS IS ACCESS GARANTED ON PARTICLUR DB OR
USER
*)DENY----THIS IS PARTICLUR USER WAITING FOR ACCESS WHEN COMMETED THE DATA THEN PERMISSION ON DB
*)REVOKE--- THIS STATEMENT USE THE USER HAVE NO PERMISIONS
regards
Whizkidash
example as below
this used to changes the permissions on database
this DCL(DATA CONTROL LANGUGE)STATEMENT
*)GRANT---THIS IS ACCESS GARANTED ON PARTICLUR DB OR
USER
*)DENY----THIS IS PARTICLUR USER WAITING FOR ACCESS WHEN COMMETED THE DATA THEN PERMISSION ON DB
*)REVOKE--- THIS STATEMENT USE THE USER HAVE NO PERMISIONS
regards
Whizkidash
|
Similar Threads
- Should replacing a 15" laptop screen with 14.1" make a difference? (Monitors, Displays and Video Cards)
- Drawbacks And Difference (C)
- how can I revoke a Terminal Server license (Windows NT / 2000 / XP)
- "difference patching" help (C)
- Windows vs Linux (IT Professionals' Lounge)
- The difference between functions and templates? (C++)
- Difference (Web Browsers)
Other Threads in the Oracle Forum
- Previous Thread: SQL help
- Next Thread: pl/sql block !
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Oracle Posts
- Today's Posts
- Unanswered Threads
2009predictions acquisition amazon.com bartz bernanke cia citrix cloudcomputing crm database dell economy editor enterprise enterprise2.0 enterprisesoftware federalreserve forbes hp ibm intellipedia internet larryellison layoffs linux loughridge mediawiki michaeljackson microsoft neverland nortel notebooks oil operatingsystem oracle palm rimm saas salesforce sap seagate socialcomputing sql sun sybase technologystocks virtualiron virtualization vmware wiki wikipedia xen yahoo zoho
