• the problem is we need db_owner or sysadmin to execute 'DBCC CHECKIDENT '.

    what about if user is a public role?

    my problem is i have a store porcedure with 'DBCC CHECKIDENT '.

    But a public role user cann't run it.