What are the challenges you face when working across database platforms? Take the survey

Grants missing from Views

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited July 1, 2003 10:05AM in SQL Compare Previous Versions
Hi Sylvain,

Just a few things to be aware of: Make sure that you haven't selected
'Ignore object permissions' in the View->Options, and also be aware that the
only permissions that get scripted are ones that specifically apply to that
object, ie if someone can access the object because they have a SYSADMIN
role, that won't be scripted.

Brian Donahue
Technical Support

"Sylvain Léger" <sleger@uapinc.com> wrote in message
> Hi,
> I am using version 2.02 and I have a problem when I use 'Create change
> scripts'. The 'Grants' are missing from the script for views (tables, SP
> and functions are OK). I tried selecting everything because I thought it
> was a dependencies problem. I hope I am doing something wrong.
> Thanks,
> Sylvain
This discussion has been closed.