Reply
Grant's order in sql?
Old 05-01-2008, 03:32 AM Grant's order in sql?
santipray's Avatar
Novice Talker

Posts: 5
Name: santi prayudani
First of all iam so sorry because my english is very bad...I hope you can understand what i want to ask...

first that I wanted to ask what was that had heard or knew about the control of data access?Especially the security of the data?

I knew that was 3, is DAC, MAC and RBAC...
I wan to ask about the principle of control access discretionary (DAC) in sql was depicted by what?

Control access discretionary meaning that the access rule that was determined by the owner of the object.
The owner took the decision whoever was permitted to access the object and the privilege what they had.
Was that the same as Grant?

What implementation was suitable to show this DAC principle with used sql??

Thank for you answer.......
santipray is offline
Reply With Quote
View Public Profile
 
Sponsored Links (We share ad revenue):
 
Old 05-01-2008, 02:04 PM Re: Grant's order in sql?
Learning Newbie's Avatar
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!
Learning Newbie is offline
Reply With Quote
View Public Profile
 
Sponsored Links (We share ad revenue):
 
Reply     « Reply to Grant's order in sql?
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML


Page generated in 0.13405 seconds with 14 queries