3

The tsql syntax throws an error about "view" in SQL Azure, but functions on SQL Server:

GRANT VIEW ON OBJECT dbo::foo TO [bar]

Can access be granted in SQL Azure to view the definition of an object outside of db_owner?

UserzRWithUz
  • 33
  • 1
  • 3

1 Answers1

4

Your syntax is incorrect. It should be

GRANT VIEW DEFINITION ON <object/schema> TO <user/role>

Example

GRANT VIEW DEFINITION ON SCHEMA::dbo TO [bar]

GRANT VIEW DEFINITION ON OBJECT::dbo.MyView TO [barRole]
Jonathan Fite
  • 8,666
  • 1
  • 23
  • 30