Thanks for all of the replies.

I suspect that I am to create the log or history table that is mentioned.  Then what do I do?  String all of the incoming parameters delimited...

Before I created this thread I did check out the Log Explorer demo.  It only works with the Northwind and Pubs DB's.

How can I use Profiler, trace sp, or triggers...

Thanks for all of the replys. Leon, your script is what I was looking for.  Thanks a million.

Thank you all for the posts.

I have a solution using the following sub select as a base and then additions to the WHERE clause:

 (

   SELECT MAX(Cast(Id AS varchar(15))) 

   FROM actual_table_name 

             GROUP...

Is "With Encryption" different than what I am using in my Stored Procedures which I included in my first post to start this thread?

Hi Alamir,

Thanks for the post.  I don't know what you mean.

Steve

I can now get the DENY to work like this:

deny select,insert,update,delete on table to "Domain\Account"

sp_helprotect null,'Domain\Account', null,o returns information showing:  ProtectType=deny for the object which is the table.

But, this does not DENY...

Well at least it makes sence as to why the DENY is bypassed.  Thanks for all of your help.

I'm told they have "God Access." I sent an email to the Network Group.  I'll post their answer when I can.

Thanks for your posts bkelly.

Hello, Here is what I have tried:

1. Database: Company_Test

2. Create a Role called: db_deny_IUD

3. Using Database Role db_deny_IUD, deny permissions on table1 (with a red X in the check box) for Insert,...

Hi hirenk,

How did you run Deny command?  I am using Roles from EM.

I cannot seem to get the Deny to work with an NT Domain Account "CompanyDom\UserName."  I have also read...

Thanks Phil, we have this all sorted out.

Yes, we have disconnected and connected and it still did not work.  I created the role and added myself to the role. Then denied I, U, & D to a table. ...

Thanks wbeetge.

To n3fp and Coach James. Thanks for the posts. I am looking into your suggestions.