0

hi everybody ...could anyone tell what is the difference between deny and revoke of privileges from a user.

4
Contributors
5
Replies
6
Views
8 Years
Discussion Span
Last Post by whizkidash
0

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.

0

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.

0

thank you so much to replay ...but i need more explanation with example ,i did not get it yet.
thanks in advance.

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.