Create SQLite database file with full permission using SQLiteConnection

Question

I'm trying to create a SQLite file setting the permission full for everyone. I've tried the following:

class StudioContext : DbContext
{
    public IDbSet<PinnedCommand> Pinned { get; set; }

    public StudioContext()
        : this(Constants.StudioDataFilePath)
    {
    }

    private StudioContext(string databasePath)
        : base(GetConnection(databasePath), true)
    {
        Configuration.ProxyCreationEnabled = false;
    }

    private static DbConnection GetConnection(string databasePath)
    {
        var dir = new DirectoryInfo(Path.GetDirectoryName(databasePath));
        if (!dir.Exists)
            dir.Create();

        GrantFullPermission(databasePath);
        var connSb = new SQLiteConnectionStringBuilder()
        {
            DataSource = databasePath,
            ForeignKeys = true,
            BinaryGUID = true,
            DateTimeFormat = SQLiteDateFormats.ISO8601,
            DateTimeKind = DateTimeKind.Utc
        };

        return new SQLiteConnection(connSb.ConnectionString);
    }

    private static void GrantFullPermission(string databasePath)
    {
        if (File.Exists(databasePath))
            return;

        var rule = new FileSystemAccessRule(new SecurityIdentifier(WellKnownSidType.WorldSid, null), FileSystemRights.FullControl, AccessControlType.Allow);
        var security = new FileSecurity();
        security.AddAccessRule(rule);
        using (File.Create(databasePath, 100, FileOptions.None, security))
        {
        }
    }
protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
        Database.SetInitializer(new SqliteDropCreateDatabaseWhenModelChanges<StudioContext>(modelBuilder));
    }

The file is created with full permission, however right after its creation, SQLite overrides it and the permission rules are lost.

How can I create the database file with permission rules set?

Jonathan Tyson · Accepted Answer · 2017-08-04 17:32:54Z

1

It doesn't look like you can when using SqliteDropCreateDatabaseWhenModelChanges. In the source code for this project, it deletes and creates a new file for the SQLite database. You may have to report an issue with that project to have it set permissions on the new database to the deleted database's permissions. As a workaround, it looks like you can use a different database creation option SqliteCreateDatabaseIfNotExists or by setting the permissions again after Database.SetInitializer has run.

answered Aug 4, 2017 at 17:32

Jonathan Tyson

4634 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create SQLite database file with full permission using SQLiteConnection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related