Hey Guys,

-No I dont have a back up plan as of yet. Howerver, this thing will be going through testing before its release and if anything comes up it will...

Hey Guys,

That worked thank you all sooo much. Lowell Sorry I didn't directly implement the code I tried to use the concepts(I didn't want to just copy it, the...

These are the ones that wont die Ill run the statment and it will return the error saying that it cannot find the object or I dont have permission. I...

I Removed my code, because I didnt feel comfterble having it up and these guys where able to show me what I was doing wrong. It wasnt working anyway :-D!

Hey guys,

Thanks for the response they are really helping. When I incorporated searching for the schema instead of just using sys. I was actually able to knock 26 down to...

- I already have the Revoke applied my code uses a cursor to run through each Object name. Unfortuantly though there are a few that its not sufficent to delete....

USE [database name]

SELECT u.name 'User', o.name 'Object', p.permission_name 'Action'

FROM sys.database_permissions p, sys.database_principals u, sys.all_objects o

WHERE o.object_id = p.major_id

AND p.grantee_principal_id = u.principal_id

AND p.grantee_principal_id IN (0, 2)

ORDER BY u.name, o.name, p.permission_name

It is...

Thats 26 is the number of Object Permissions sorry I should have clarrified that!

First thanks for the reply,

Secondly I am trying to delete access to Object Permissions for the public user. (I am not worried about the side affects, it has to be...

26 is ther number of Object permissions that I cant delete. There is a set number every time that it is installed I was hoping, it might help. Im running...

TY

Fixed my second issue as well by using another variable and execution statment!

Thanks! ... I guess

Hey,

I am updating my post I figured out the first problem, I cant use Rand() in that context I assume. Because when I re-wrote it without it worked!