hi everybody ...could anyone tell what is the difference between deny and revoke of privileges from a user.
baheddad
0
Newbie Poster
Recommended Answers
Jump to PostPermissions 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.
Jump to PostOnly 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 …
All 5 Replies
Cronless
4
Light Poster
debasisdas
580
Posting Genius
Featured Poster
baheddad
0
Newbie Poster
debasisdas
580
Posting Genius
Featured Poster
whizkidash
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.