YAFLogo

rohanphillips
5 years ago
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.3
5 years ago
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?

rohanphillips
5 years ago
Thanks for getting back to me.

Played around with permissions some more, seems to have fixed the issue
YAF Logo Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved
About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button