Error trying to create a Proc in the database

Question

Error trying to create a Proc in the database

Navigation

#1 by (0 votes)

0

I'm trying to run a Stored Procedure in the database and it's giving this message:

Can not grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself

How do I resolve this?

If Proc already exists and I just change it, I squeeze. I just can not run a new one.

I made this select:

SELECT * FROM fn_my_permissions(NULL, 'SERVER');
GO

And I received this:

server ;; CONNECT SQL

server ;; VIEW ANY DATABASE

What does this mean?

sql sql-server tsql

asked by anonymous 17.04.2017 / 21:36

1 answer

Alert or Popup javascript after form validation in SharePoint 2013 Error while compiling project in Visual Basic 6

score 0 · Answer 1

Following the guidance of Motta, which I assign to him the resolution of my problem, I did the following to solve. I commented GRANT at the end of PROC and circled PROC in development environment. This solved my problem.