Need help . Stored proc creates view dynamically and grants select priv to the list of user . It works for user who created stored proc.
When other user runs it gets message that user doesn't have privelege to grant priv to the view .
Any help greatly appreaciated