Re: Newbie: I don't understand user permissions for table access
From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 07/28/04
- Next message: Matthew Bando: "SQL Server Interview questions"
- Previous message: Matthew Bando: "Oracle"
- In reply to: Larry Woods: "Newbie: I don't understand user permissions for table access"
- Next in thread: Larry Woods: "Re: Newbie: I don't understand user permissions for table access"
- Reply: Larry Woods: "Re: Newbie: I don't understand user permissions for table access"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 28 Jul 2004 09:22:20 -0500
wrong
table permissions are important. They are required in order to
access/update/delete data.
HOW are you connecting to SQL Server?
NT Authentication?
SQL Server Authentication?
If SQL Server auth, what account are you using? sa? If so, that is the
"GOD" account. You have full permissions to do anything and everything.
If you are using NT auth, what rights does your NT account have? Is it
assigned server or database roles that allow the activities that you are
performing?
Finally, what rights/permissions have been granted to the PUBLIC role?
Often (unfortunately) companies simply grant all rights to the public
role...and then evey account (SQL and NT) inherit the rights assigned to the
public role. For obvious reasons this is a bad security model.
SQL Server has a strong security model and it works well when it is setup by
someone who knows what they are doing. In the wrong hands....
-- Keith "Larry Woods" <larry@NOSPAMlwoods.com> wrote in message news:eM31J1KdEHA.3864@TK2MSFTNGP10.phx.gbl... > I have a SQL Server database that has database userid/password protection. > When I open the database through EM I can add/delete/modify any table, but > when I look at the permissions for any of the tables there are NO options > set for any user of the database! I don't understand the purpose of the > permissions, I guess, since they don't have to be set in order to get access > to the tables. > > TIA, > > Larry Woods > >
- Next message: Matthew Bando: "SQL Server Interview questions"
- Previous message: Matthew Bando: "Oracle"
- In reply to: Larry Woods: "Newbie: I don't understand user permissions for table access"
- Next in thread: Larry Woods: "Re: Newbie: I don't understand user permissions for table access"
- Reply: Larry Woods: "Re: Newbie: I don't understand user permissions for table access"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
