![]() |
| Sponsored Links (We share ad revenue): |
|
|
Re: Grant's order in sql? |
|
Moderator
![]()
Latest Blog Post:
My Favorite Isaac Asimov Story Posts: 4,068
Name: John Alexander
|
What database engine are you using? SQL Server? Oracle? Access? dBase or Paradox? Postgres?
In SQL Server, we tend to secure access to database objects either by granting and revoking permission for individual user accounts, or by doing that at the role level instead. Say you work for a big company, with 20 customer service representatives. Instead of granting all 20 of them access to 15 objects they might need to do their jobs (that would be a lot of work!) it would be more common to make a role called CustServRep, or something like it, add these 20 people to that role, and then rant the role permission to the 15 objects. It's also very common to revoke permission to the tables from almost everyone, but to leave views and procedures in place. This adds a great deal of security, in a lot of different ways. People can't make unauthorized changes, can't see data that isn't meant for them, and it becomes harder to accidentally break things.
__________________
HungarianNotation is the last resort of scoundrels. Why not the first resort? That's where it counts! |
|
|
|
| Sponsored Links (We share ad revenue): |
| Thread Tools | |
|
|
| Webmaster Resources Marketplace: |
| Software Development Company | Webhosting.UK.com |
| Web Templates | Text Link Brokers | Stock Photos |