October 28, 2002 at 10:32 am
It's seems very confusing. May be because it was much simpler for me in Oracle.
I have few users in all of my databases as part of DBO role. I want this user to give only necessary privileges, like all DDL, DML and all rights about procedure.
First of all when I try to look up what rights does DBO have (with sp_helpdbfixedrole) it gives a list like all DDL,checkpoint, select on any object etc. It doesn't give me list of exec. statements like 'create table', 'alter table'. How do I know what exactly this role has?
I want to give most of this rights to my new role except Backup/ restore and few others.
Second when I run query like 'grant create table to myrole' I know it's granted, But where do I see the list. Any time I try to see I just see permission on objects. I don't see permission on DDL.
Can someone please help?
Thanks.
October 28, 2002 at 10:44 am
sp_helprotect will get you most of what you want, but it will be kludgy and I think you will need to run it for someone in the role.
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply