Permission to execute commands and stored procedures, and access to objects in an archive database is the same as for a traditional database loaded with the same database dump on the same server.
When an archive database is loaded with norecovery, access to that database is limited to users with sa_role, or the database owner.
