> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Alter user settings exception

> Handing the an exception thrown when altering user settings

{frontMatter.description}

<h2 id="dbexception-cannot-update-user-default-in-usersxml-because-this-storage-is-readonly-access_storage_readonly">
  DB::Exception: Cannot update user `default` in users.xml because this storage is readonly. (ACCESS\_STORAGE\_READONLY)
</h2>

When you try to alter a user's settings, you may encounter the above exception.

Here are a few options to troubleshoot this error:

<h2 id="edit-usersxml-directly">
  Edit users.xml directly
</h2>

You can edit or add the desired settings for a specific user in `users.xml` directly in the file `/etc/clickhouse-server/users.d`.

Read more about `users.xml` [here](/concepts/features/configuration/settings/settings-profiles).

<h2 id="create-another-user">
  Create another user
</h2>

You can create another user with the specified settings, then connect to ClickHouse using that new user.

View [this page](/reference/statements/create/user) to learn how to create users.

<h2 id="enable-sql-driven-access-control">
  Enable SQL-driven access control
</h2>

You can enable SQL-drive access control and account management for the default user. The steps to enable this are specified in this [page](/concepts/features/security/access-rights#enabling-access-control).