grant

[cmsbuffet]

How do I grant execute to the read only user? How does read only user show in the command?

 grant privileges to ....

 

[jbenson001]

Grant Execute ON "sp name" to "the user you created

 

[cmsbuffet]

So the code below is OK?

Drop Procedure A
go
Create Procedure A
go
Grant Execute ON A to READONLYUSER
go

And

Drop Function A
go
Create Function A
go
Grant Execute ON A to READONLYUSER
go

 

[jbenson001]

Try it and find out.