permissions not working

Hi. I have a SQL Server 2000 database,using Windows Authentication,
and have created some new roles and assigned permissions to the
various tables, views and sprocs. However, the permissions are not
working. When I log on as a user in one of the roles, i still have
access to insert, update, delete records in tables that i have
specifically denied permissions on (they should only have select
permissions which they have). I am able to log onto Query Analyzer
and do everything with the table that i should not be able to do. The
user is only a member of public and this role. The objects are all
owned by dbo. Any ideas?

Thanks,
jenn
.

Relevant Pages

  • Re: Adp and SQL Server is there a way to query SQL permissions to control userforms?
    ... Use Windows authentication, and give some ... groups access to some sprocs and views and not to others. ... If you give me delete permissions for a view, ... Can you not design your app so it connects with a SQL Server account rather ...
    (comp.databases.ms-access)
  • RE: MELL and SQL
    ... At this point I'm logged in as admin and since ... have the necessary permissions for the installation. ... > Most third party apps don't use Windows Authentication, they use SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: Using Windows Authentication
    ... Doug Steele, Microsoft Access MVP ... I can programmatically control their permissions. ... I'm using Access 2007, SQL Server 2005, Windows ... SQL is set up for Windows Authentication because my users already ...
    (microsoft.public.access.security)
  • RE: Help with database transfer
    ... if using windows authentication you just need to look at the users and roles ... by default sql will allow local admins on the box to have dbo priveledges on ... "David" wrote: ... > I am having permissions issues now. ...
    (microsoft.public.sqlserver.server)
  • Re: OWA Troubles
    ... I also have Integrated Windows Authentication selected. ... >> We recently put an intranet site on our IIS server that hosts OWA. ... so I'm sure its permissions that's causing the problem. ...
    (microsoft.public.exchange.admin)