Re: Newbie: I don't understand user permissions for table access

From: Larry Woods (larry_at_NOSPAMlwoods.com)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 08:23:35 -0700

Thanks for the quick response from all you guys. Now, tackle the other
email that I sent! ;-)

Why can I get to my SQL Server db tables through EM but NOT through a Access
project? In the Access project I can read/select any table in the database,
but no modify/add/delete capabilities.

????????????

Thanks, again.

Larry Woods

"Peter the Spate" <anonymous@discussions.microsoft.com> wrote in message
news:5c1a01c474b4$b6cba070$a301280a@phx.gbl...
> Hi Larry,
>
> ob_owner means you can do anything to that particular
> database. If there are other databases you can attack to
> then you may have different access rights.
>
> I would sugest you have a look at
> http://msdn.microsoft.com/library/default.asp?
> url=/library/en-us/architec/8_ar_da_8yur.asp and its sub
> groups for a bit of background
>
> Peter
> MCDBA
>
>
> >-----Original Message-----
> >My database is remote to my workstation. I am using EM
> on the workstation.
> >The database has a userid/password (not 'sa') but the
> userid has "public"
> >and "db_owner" roles. Does the "db_owner" have complete
> access to all
> >tables/fields WITHOUT specifying anything in the
> permissions dialogs?
> >
> >My "public" role only has "SELECT" and "EXEC" permissions.
> >
> >Thanks, again.
> >
> >Larry Woods
> >
> >And,
> >"Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in
> message
> >news:%23PTfc5KdEHA.3728@TK2MSFTNGP09.phx.gbl...
> >> 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
> >> >
> >> >
> >>
> >
> >
> >.
> >

Relevant Pages

  • Re: Refresh Problem
    ... Locking/Unlocking Workstation: ... Set the database field RWUser to the user's ID for locking, ... window does not update every time. ... refresh does what it is supposed to do. ...
    (microsoft.public.fox.programmer.exchange)
  • RE: WMI and Joining Domain (sysprep related)
    ... If you have a database of info like the MAC, Serial, Computer name, domain, ... I have vbscript examples for renaming the workstation and can manually ...
    (microsoft.public.scripting.vbscript)
  • Re: Access 2002 Runtime - networking errors
    ... have you checked the References on each workstation? ... >I manage an Access 2002 runtime database remotely, ... I did not change the code behind the command ...
    (microsoft.public.access.setupconfig)
  • Re: different environment fails to fill a dataset
    ... Are you sure that the login on the Test system has the database Planit as ... Andrew J. Kelly SQL MVP ... on the test workstation but not my development station. ...
    (microsoft.public.sqlserver.clients)
  • Re: Problems networking Access
    ... linked to the backend on the server. ... When I enter records into the database from the workstation, ... A good approach is to build some type of search form, ...
    (comp.databases.ms-access)