Re: assigning DB-user to server role

From: Cindy Gross (cgross_at_online.microsoft.com)
Date: 01/28/04 

Date: Wed, 28 Jan 2004 20:44:00 GMT

Perhaps if you used profiler while you recreate your scenario in EM (create
the roles, grant permissions to the role, add users to role, try to execute
your query as that user) then posted the tsql scripts that would help us
figure out what's going on.

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Relevant Pages

  • Re: Relocating application architecture and compiler support
    ... > program, load it into the same address space, execute it (with the ... in the tss/360 scenario ... ... address constants needing swizzling were kept in a different ...
    (comp.arch.embedded)
  • Disable and Rebuild or Drop and recreate Index
    ... Here is my scenario. ... columns that are frequently used in those queries, ... where I have to import new weekly data. ... disable and rebuild all index or just drop and recreate. ...
    (comp.databases.ms-sqlserver)
  • Re: Protecting database structure
    ... Don't GRANT permissions to the underlauying tables, unstead use EXECUTE ... Alos,perform regular BACKUP on user databases as well as system such ...
    (microsoft.public.sqlserver.security)
  • Re: Grant Insert Permission Freezing
    ... Execute sp_who to list current activity. ... Perhaps there is a rogue process blocking your request. ... I kicked everyone out of the database so I am the only ... But when I try to grant permissions to table YYY the ...
    (microsoft.public.sqlserver.security)
  • Executing Macro Help
    ... I've got this combo box set up so that when I pick one scenario, ... executes a macro which changes a few values on the current sheet. ... do is change the scenario and execute the macro to change ONLY the ...
    (microsoft.public.excel.programming)