Sql Server Management Studio 2008 not scripting table permissions

Sql Server Management Studio 2008 is not scripting table permissions even when I select the option to script object level permissions. Is this a bug or is there another way to do this? It is creating permissions for stored procs, but not for tables. I am a sysadmin.

If it doesn't work, are there free sql server tools to script the permissions?
jentel2Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

QPRCommented:
first thing to check (and apologies if you have)... can you be sure that permission have been defined for this/those tables?
If you script out a table with no specific permissions defined then there will be no "grant" text in the script - even if you choose the option to script object permissions.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jentel2Author Commented:
This seems to be a bug as noted by someone elsewhere.
0
QPRCommented:
never heard of this and cant reproduce - whio said its a bug?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

QPRCommented:
u have set script permissions to true under query options?
tools-options-scripting
0
jentel2Author Commented:
Are you sure your management Studio is the 2008 version and not 2005?

It seems all that setting does is that whatever setting you have in there is the default for the script permissions in the Generate scripts wizard.

It doesn't control whether the wizard is able to create the permissions or not.
0
jentel2Author Commented:
I am asking about the version because someone said it works for MS 2005 but not for MS 2008.
0
QPRCommented:
My SSMS is 2005 and this is a 2005 zone.
I didn't notice the 2008 in the title - sorry
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.