YAFLogo

rohanphillips
2017-12-04T22:56:24Z
Hi

I'm receiving the following. I've gone out and verified what I thought were the necessary superuser permissions for the database so that access could be given. Wonder if someone has any information on what permissions I'd need to change to not get this error?

Thanks

FILE:

mssql/upgrade/tables.sql

ERROR:

Cannot find the object 'yaf_Active', because it does not exist or you do not have permission.

Cannot find the object 'yaf_Active', because it does not exist or you do not have permission.

STATEMENT:

if exists (select top 1 1 from sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[yaf_Active]') and type in (N'U'))

grant delete on [dbo].[yaf_Active] to public

exec('delete from [dbo].[yaf_Active]')

revoke delete on [dbo].[yaf_Active] from public

Sponsor
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.0
2017-12-05T17:30:02Z
Originally Posted by: rohanphillips 

Hi

I'm receiving the following. I've gone out and verified what I thought were the necessary superuser permissions for the database so that access could be given. Wonder if someone has any information on what permissions I'd need to change to not get this error?

I assume you do an upgrade? The yaf tables exist in your database? Also does the user defined in the db connection string in the web.config have the correct permission or is the db owner?


UserPostedImage
rohanphillips
2017-12-05T22:47:07Z
Thanks for getting back to me.

Played around with permissions some more, seems to have fixed the issue